DBA Data[Home] [Help]

APPS.PO_REQS_CONTROL_SV dependencies on PO_AGENTS

Line 40: FROM PO_AGENTS POA

36: OR (PODT.SECURITY_LEVEL_CODE = 'PURCHASING'
37: AND PODT.access_level_code = 'FULL'
38: AND EXISTS
39: (SELECT 'Is the user an agent'
40: FROM PO_AGENTS POA
41: WHERE POA.AGENT_ID = X_agent_id
42: AND sysdate BETWEEN POA.start_date_active
43: AND nvl(POA.end_date_active,sysdate+1)))
44: OR (PODT.SECURITY_LEVEL_CODE = 'HIERARCHY'

Line 71: FROM PO_AGENTS POA

67: OR (PODT.SECURITY_LEVEL_CODE = 'PURCHASING'
68: AND PODT.access_level_code IN ('MODIFY','FULL')
69: AND EXISTS
70: (SELECT 'Is the user an agent'
71: FROM PO_AGENTS POA
72: WHERE POA.AGENT_ID = X_agent_id
73: AND sysdate BETWEEN POA.start_date_active
74: AND nvl(POA.end_date_active,sysdate+1)))
75: OR (PODT.SECURITY_LEVEL_CODE = 'HIERARCHY'