APPS.PO_APPROVE_SV dependencies on PO_EMPLOYEE_HIERARCHIES

Line 200: FROM po_employee_hierarchies peh,

196: SELECT DISTINCT pps.name,
197: pps.position_structure_id
198: INTO x_approval_path,
199: x_approval_path_id
200: FROM po_employee_hierarchies peh,
201: per_position_structures pps
202: WHERE peh.position_structure_id = pps.position_structure_id
203: AND pps.position_structure_id = x_default_approval_path_id
204: AND peh.employee_id = x_forward_from_id;