APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PER_PERIODS_OF_SERVICE

Line 2020: PER_PERIODS_OF_SERVICE PS

2016: SELECT poeh.superior_id, poeh.superior_level, cwk.full_name
2017: FROM PER_ALL_PEOPLE_F CWK,
2018: PO_EMPLOYEE_HIERARCHIES POEH,
2019: PER_ALL_ASSIGNMENTS_F A,
2020: PER_PERIODS_OF_SERVICE PS
2021: WHERE poeh.position_structure_id = p_approval_path_id
2022: AND poeh.employee_id = p_empid
2023: AND cwk.person_id = poeh.superior_id
2024: AND poeh.superior_level > 0