APPS.HR_PERSON_DEPLOYMENT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1028: from per_periods_of_service pds

1024: and past.per_system_status = 'ACTIVE_ASSIGN';
1025: --
1026: cursor csr_home_pds_details(p_person_id number) is
1027: select pds.period_of_service_id, pds.object_version_number
1028: from per_periods_of_service pds
1029: where pds.person_id = p_person_id
1030: and l_dpl_rec.start_date >= pds.date_start
1031: and pds.actual_termination_date is null;
1032: --

Line 1214: l_varray_d(6):='PER_PERIODS_OF_SERVICE';

1210: l_varray_d(2):='PER_PAY_PROPOSALS';
1211: l_varray_d(3):='PER_CONTACTS';
1212: l_varray_d(4):='Contact Relship Developer DF';
1213: l_varray_d(5):='PER_PEOPLE_EXTRA_INFO';
1214: l_varray_d(6):='PER_PERIODS_OF_SERVICE';
1215: l_varray_d(7):='PER_PDS_DEVELOPER_DF';
1216: --
1217: -- Added for bug 5491169
1218: l_varray_d(8):='PER_PEOPLE';

Line 2217: per_periods_of_service pds

2213: cursor csr_host_assignments(p_start_date date) is
2214: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2215: from per_all_assignments_f asg,
2216: hr_person_deployments pdt,
2217: per_periods_of_service pds
2218: where asg.person_id = pdt.to_person_id
2219: and pdt.person_deployment_id = p_person_deployment_id
2220: and asg.period_of_service_id = pds.period_of_service_id
2221: and pds.date_start = p_start_date

Line 2530: from per_periods_of_service pds

2526: l_dpl_rec csr_person_deployment%rowtype;
2527: --
2528: cursor csr_host_pds(p_person_id number) is
2529: select pds.period_of_service_id, pds.object_version_number
2530: from per_periods_of_service pds
2531: where pds.person_id = p_person_id
2532: and pds.date_start = L_DPL_REC.START_DATE;
2533: --
2534: -- following cursor needs to get the assignments which were suspended in line with