APPS.HR_PERSON_DEPLOYMENT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1026: from per_periods_of_service pds

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

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

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

Line 2192: per_periods_of_service pds

2188: cursor csr_host_assignments(p_start_date date) is
2189: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2190: from per_all_assignments_f asg,
2191: hr_person_deployments pdt,
2192: per_periods_of_service pds
2193: where asg.person_id = pdt.to_person_id
2194: and pdt.person_deployment_id = p_person_deployment_id
2195: and asg.period_of_service_id = pds.period_of_service_id
2196: and pds.date_start = p_start_date

Line 2505: from per_periods_of_service pds

2501: l_dpl_rec csr_person_deployment%rowtype;
2502: --
2503: cursor csr_host_pds(p_person_id number) is
2504: select pds.period_of_service_id, pds.object_version_number
2505: from per_periods_of_service pds
2506: where pds.person_id = p_person_id
2507: and pds.date_start = L_DPL_REC.START_DATE;
2508: --
2509: -- following cursor needs to get the assignments which were suspended in line with