DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ALL_PEOPLE_F

Line 1345: per_all_people_f p,

1341: -- improve performance
1342: CURSOR direct_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1343: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1344: FROM po_employee_hierarchies_all poeh,
1345: per_all_people_f p,
1346: per_all_assignments_f a,
1347: per_assignment_status_types past,
1348: per_periods_of_service b
1349: WHERE a.person_id = p.person_id

Line 1411: per_all_people_f p,

1407:
1408: CURSOR hier_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1409: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1410: FROM po_employee_hierarchies_all poeh,
1411: per_all_people_f p,
1412: per_all_assignments_f a,
1413: per_assignment_status_types past,
1414: per_periods_of_service b
1415: WHERE a.person_id = p.person_id