DBA Data[Home] [Help]

APPS.PO_APPROVE_SV dependencies on PER_POSITION_STRUCTURES

Line 160: FROM per_position_structures pps,

156: SELECT pps.name,
157: pah.approval_path_id
158: INTO x_approval_path,
159: x_approval_path_id
160: FROM per_position_structures pps,
161: po_action_history pah
162: WHERE pah.approval_path_id = pps.position_structure_id
163: AND pah.object_id = x_object_id
164: AND pah.object_type_code = x_document_type_code

Line 201: per_position_structures pps

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;
205: