APPS.PQP_GB_SWF_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 831: per_assignment_status_types pas

827: max(asg1.effective_end_date) over( partition by assignment_id) effective_end_date,
828: first_value(location_id)over( partition by assignment_id order by asg1.effective_end_date desc ) location_id,
829: asg1.assignment_id
830: from per_all_assignments_f asg1,
831: per_assignment_status_types pas
832: where asg1.assignment_status_type_id = pas.assignment_status_type_id
833: and pas.per_system_status = 'ACTIVE_ASSIGN') min_max
834: where asg.person_id between stperson and endperson
835: and asg.business_group_id + 0 = g_business_group_id

Line 921: per_assignment_status_types pas

917:
918: (select first_value(location_id)over( partition by assignment_id order by asg1.effective_end_date desc ) location_id,
919: asg1.assignment_id
920: from per_all_assignments_f asg1,
921: per_assignment_status_types pas
922: where asg1.assignment_status_type_id = pas.assignment_status_type_id
923: and pas.per_system_status = 'ACTIVE_ASSIGN') loc
924: where asg.person_id between stperson and endperson
925: and asg.business_group_id + 0 = g_business_group_id

Line 1254: per_assignment_status_types pas

1250: cursor csr_cont_eff_date_asg is
1251: select max(effective_end_date)
1252: from pay_assignment_actions act,
1253: per_all_assignments_f paa,
1254: per_assignment_status_types pas
1255: where act.assignment_action_id = p_assactid
1256: and act.assignment_id = paa.assignment_id
1257: and paa.assignment_status_type_id = pas.assignment_status_type_id
1258: and pas.per_system_status = 'ACTIVE_ASSIGN';

Line 2712: per_assignment_status_types pas

2708: decode(to_char(max(paa.effective_end_date) ,'YYYY-MM-DD'),'4712-12-31',null,
2709: to_char(max(paa.effective_end_date) ,'YYYY-MM-DD'))contract_end_date_dcsf,
2710: to_char(min(paa.effective_start_date) ,'YYYY-MM-DD') date_of_arrival_dcsf
2711: from per_all_assignments_f paa,
2712: per_assignment_status_types pas
2713: where paa.assignment_status_type_id = pas.assignment_status_type_id
2714: and pas.per_system_status = 'ACTIVE_ASSIGN'
2715: and paa.assignment_id = p_assignment_id;
2716:

Line 3999: per_assignment_status_types pas

3995: cursor csr_asg_no(p_census_day in date) is
3996: select paa.assignment_id , paa.employment_category, paa.assignment_number
3997: from pay_assignment_actions act,
3998: per_all_assignments_f paa,
3999: per_assignment_status_types pas
4000: where act.assignment_action_id = p_assactid
4001: and act.assignment_id = paa.assignment_id
4002: and p_census_day between paa.effective_start_date and paa.effective_end_date
4003: and paa.assignment_status_type_id = pas.assignment_status_type_id