DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ALL_PEOPLE_F

Line 1356: per_all_people_f p,

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
1360: AND poeh.business_group_id in (select fsp.business_group_id

Line 1422: per_all_people_f p,

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
1426: AND poeh.business_group_id in (select fsp.business_group_id