DBA Data[Home] [Help]

APPS.PA_SIGNON dependencies on FND_GRANTS

Line 133: FROM fnd_grants fg,

129: (
130: ORGANIZATION_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

Line 155: -- fnd_grants fg /*bug#4904076 Perf bug*/

151: )
152: SELECT ppp.PROJECT_ID
153: FROM pa_project_parties ppp,
154: fnd_user fu
155: -- fnd_grants fg /*bug#4904076 Perf bug*/
156: WHERE fu.USER_ID = fnd_global.user_id AND
157: fu.EMPLOYEE_ID = ppp.RESOURCE_SOURCE_ID AND
158: --start rem | 24-JUN-2009 cklee fxied bug:6708625 |
159: object_type = 'PA_PROJECTS' --(since this is reading project records)