APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PER_PERIODS_OF_PLACEMENT

Line 312: from per_periods_of_placement) po

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
314: and nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)
315: and asgn.person_id = po.person_id
316: and po.person_id = p_person_id

Line 329: from per_periods_of_placement) po

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
331: and asgn.primary_flag = 'Y'
332: and asgn.assignment_type in ('E', 'C') --Added for 2911451
333: and po.person_id = p_person_id

Line 346: from per_periods_of_placement) po

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
348: and asgn.primary_flag = 'Y'
349: and asgn.assignment_type in ('E', 'C')
350: and po.person_id = p_person_id

Line 799: select person_id, date_start from per_periods_of_placement) po

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;
802: EXCEPTION
803: WHEN OTHERS THEN