DBA Data[Home] [Help]

APPS.PO_REQS_CONTROL_SV dependencies on PO_SYSTEM_PARAMETERS

Line 49: PO_SYSTEM_PARAMETERS POSP

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)));
53:

Line 80: PO_SYSTEM_PARAMETERS POSP

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)));
84: