DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_EMPLOYEE_HIERARCHIES_ALL

Line 1355: FROM po_employee_hierarchies_all poeh,

1351: -- Bug12360617 Contingent worker should be defaulted on the forward_to
1352: -- field.
1353: CURSOR direct_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1354: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1355: FROM po_employee_hierarchies_all poeh,
1356: per_all_people_f p,
1357: per_all_assignments_f a,
1358: per_assignment_status_types past
1359: WHERE a.person_id = p.person_id

Line 1421: FROM po_employee_hierarchies_all poeh,

1417: -- Bug12360617 Contingent worker should be defaulted on the forward_to
1418: -- field.
1419: CURSOR hier_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1420: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1421: FROM po_employee_hierarchies_all poeh,
1422: per_all_people_f p,
1423: per_all_assignments_f a,
1424: per_assignment_status_types past
1425: WHERE a.person_id = p.person_id