APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PER_PERIODS_OF_SERVICE

Line 309: (select person_id, actual_termination_date from per_periods_of_service

305: is
306: select asgn.assignment_id
307: from per_all_assignments_f asgn, /* from per_assignments_f per Commented for bug 2983491 , Added per_all_assignments_f for it*/
308: per_assignment_status_types status,
309: (select person_id, actual_termination_date from per_periods_of_service
310: union all
311: select person_id, actual_termination_date
312: from per_periods_of_placement) po
313: where asgn.person_id = p_person_id

Line 326: (select person_id, actual_termination_date from per_periods_of_service

322: cursor get_primary_assignment
323: is
324: select asgn.assignment_id
325: from per_all_assignments_f asgn, /* from per_assignments_f per Commented for bug 2983491 , Added per_all_assignments_f for it*/
326: (select person_id, actual_termination_date from per_periods_of_service
327: union all
328: select person_id, actual_termination_date
329: from per_periods_of_placement) po
330: where asgn.person_id = p_person_id

Line 343: (select person_id, actual_termination_date from per_periods_of_service

339: cursor get_job_on_assignment
340: is
341: select asgn.job_id
342: from per_all_assignments_f asgn, /* from per_assignments_f per Commented for bug 2983491 , Added per_all_assignments_f for it*/
343: (select person_id, actual_termination_date from per_periods_of_service
344: union all
345: select person_id, actual_termination_date
346: from per_periods_of_placement) po
347: where asgn.person_id = p_person_id

Line 797: (select person_id, date_start from per_periods_of_service

793: BEGIN
794: SELECT max(DATE_START)
795: INTO l_latest_start_date
796: FROM
797: (select person_id, date_start from per_periods_of_service
798: union all
799: select person_id, date_start from per_periods_of_placement) po
800: WHERE po.person_id = l_person_id
801: AND trunc(po.date_start) <= trunc(p_assignment_start_date); -- Added for bug 4465862;