DBA Data[Home] [Help]

APPS.PA_SIGNON dependencies on DUAL

Line 22: FROM dual;

18:
19: /*
20: SELECT USERENV('SESSIONID')
21: INTO l_session_id
22: FROM dual;
23:
24: --------------------------------------------------------------------------------
25: --Session ID will be 0 if we schedule to run the workbooks
26: --When the package is run from the DBMS_JOBS queue the userenv('SESSIONID') is

Line 137: FROM dual) prj_auth_menu

133: FROM fnd_grants fg,
134: fnd_objects fob,
135: (SELECT nvl(pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH'),-1) menu_id
136: ,nvl(PA_SECURITY_PVT.GET_GRANTEE_KEY, -1) grantee_key
137: FROM dual) prj_auth_menu
138: WHERE fg.INSTANCE_TYPE = 'INSTANCE'
139: AND fg.GRANTEE_TYPE = 'USER'
140: AND fg.OBJECT_ID = fob.OBJECT_ID
141: AND fob.OBJ_NAME = 'ORGANIZATION'