DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PER_PERIODS_OF_PLACEMENT

Line 2041: PER_PERIODS_OF_PLACEMENT PP

2037: POEH.SUPERIOR_ID , POEH.SUPERIOR_LEVEL, CWK.FULL_NAME
2038: FROM PER_ALL_PEOPLE_F CWK,
2039: PO_EMPLOYEE_HIERARCHIES POEH,
2040: PER_ALL_ASSIGNMENTS_F A,
2041: PER_PERIODS_OF_PLACEMENT PP
2042: WHERE poeh.position_structure_id = p_approval_path_id
2043: AND poeh.employee_id = p_empid
2044: AND cwk.person_id = poeh.superior_id
2045: AND poeh.superior_level > 0