APPS.JTF_CAL_GRANTS_PVT dependencies on FND_MENUS

Line 176: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos

172:
173: /** Define a cursor C_CAL to fetch Calendar Read and Full Access for the given p_GranterID **/
174: CURSOR C_CAL IS
175: SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
176: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
177: WHERE fgs.object_id = fos.object_id
178: AND fos.obj_name = CALENDAR_OBJECT
179: AND fgs.menu_id = fmu.menu_id
180: AND fmu.menu_name IN (CALENDAR_READ_PRIVILEGE

Line 193: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos

189:
190: /** Define a cursor C_CAL to fetch Tasks Read and Full Access for the given p_GranterID **/
191: CURSOR C_TASKS IS
192: SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
193: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
194: WHERE fgs.object_id = fos.object_id
195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT
196: AND fgs.menu_id = fmu.menu_id
197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE

Line 618: FROM FND_GRANTS fgs, FND_MENUS fmu

614: AND program_name = 'CALENDAR'; */
615:
616: cursor C is
617: SELECT fgs.grant_guid
618: FROM FND_GRANTS fgs, FND_MENUS fmu
619: WHERE grantee_key = p_resourceId
620: AND instance_pk1_value = p_groupId
621: AND instance_pk2_value = 'RS_GROUP'
622: AND program_name = 'CALENDAR'