DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1358: per_assignment_status_types past

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
1361: from financials_system_parameters fsp)
1362: AND a.primary_flag = 'Y'

Line 1424: per_assignment_status_types past

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
1427: from financials_system_parameters fsp)
1428: AND a.primary_flag = 'Y'