DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1347: per_assignment_status_types past,

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
1350: AND poeh.business_group_id in (select fsp.business_group_id
1351: from financials_system_parameters fsp)

Line 1413: per_assignment_status_types past,

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
1416: AND poeh.business_group_id in (select fsp.business_group_id
1417: from financials_system_parameters fsp)