DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_EMPLOYEE_HIERARCHIES_ALL

Line 1344: FROM po_employee_hierarchies_all poeh,

1340: -- Bug 5386007: Replaced hr_employees_current_v with base tables to
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

Line 1410: FROM po_employee_hierarchies_all poeh,

1406: AND pera.effective_end_date;
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