DBA Data[Home] [Help]

APPS.PA_SIGNON dependencies on PA_SECURITY_PVT

Line 135: (SELECT nvl(pa_security_pvt.get_menu_id('PA_PRM_PROJ_AUTH'),-1) menu_id

131: )
132: SELECT INSTANCE_PK1_VALUE
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'

Line 136: ,nvl(PA_SECURITY_PVT.GET_GRANTEE_KEY, -1) grantee_key

132: SELECT INSTANCE_PK1_VALUE
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