APPS.PO_REQS_CONTROL_SV dependencies on PO_EMPLOYEE_HIERARCHIES

Line 48: FROM PO_EMPLOYEE_HIERARCHIES POEH,

44: OR (PODT.SECURITY_LEVEL_CODE = 'HIERARCHY'
45: AND PODT.access_level_code = 'FULL'
46: AND X_agent_id IN
47: (SELECT POEH.SUPERIOR_ID
48: FROM PO_EMPLOYEE_HIERARCHIES POEH,
49: PO_SYSTEM_PARAMETERS POSP
50: WHERE POEH.EMPLOYEE_ID = X_doc_agent_id
51: AND POEH.POSITION_STRUCTURE_ID =
52: POSP.SECURITY_POSITION_STRUCTURE_ID)));

Line 79: FROM PO_EMPLOYEE_HIERARCHIES POEH,

75: OR (PODT.SECURITY_LEVEL_CODE = 'HIERARCHY'
76: AND PODT.access_level_code IN ('MODIFY','FULL')
77: AND X_agent_id IN
78: (SELECT POEH.SUPERIOR_ID
79: FROM PO_EMPLOYEE_HIERARCHIES POEH,
80: PO_SYSTEM_PARAMETERS POSP
81: WHERE POEH.EMPLOYEE_ID = X_doc_agent_id
82: AND POEH.POSITION_STRUCTURE_ID =
83: POSP.SECURITY_POSITION_STRUCTURE_ID)));