APP-PAY-06153 per_pdp_bus.chk_actual_termination_date
select * from per_all_people_f
where 1=1
and first_name like '%AXXXX%'
and last_name like '%DaAAAAA%'
select * from per_all_assignments_f
where 1=1
and person_id =XXX
and BUSINESS_GROUP_ID=XX
--create table bolinf.xxta_per_all_assignments_f as (select * from per_all_assignments_f
where 1=1
and person_id =XXXXX
and BUSINESS_GROUP_ID=81
and ASSIGNMENT_NUMBER='053202')
commit;
--update per_all_assignments_f
set PERIOD_OF_PLACEMENT_DATE_START = to_date('09-JUN-2014','DD-MON-RRRR')
where 1=1
and person_id =XXXX
and BUSINESS_GROUP_ID=XXX
and ASSIGNMENT_NUMBER='XXXX'
commit;
select * from per_all_people_f
where 1=1
and first_name like '%AXXXX%'
and last_name like '%DaAAAAA%'
select * from per_all_assignments_f
where 1=1
and person_id =XXX
and BUSINESS_GROUP_ID=XX
--create table bolinf.xxta_per_all_assignments_f as (select * from per_all_assignments_f
where 1=1
and person_id =XXXXX
and BUSINESS_GROUP_ID=81
and ASSIGNMENT_NUMBER='053202')
commit;
--update per_all_assignments_f
set PERIOD_OF_PLACEMENT_DATE_START = to_date('09-JUN-2014','DD-MON-RRRR')
where 1=1
and person_id =XXXX
and BUSINESS_GROUP_ID=XXX
and ASSIGNMENT_NUMBER='XXXX'
commit;
No comments:
Post a Comment