APPS.CAC_SYNC_TASK_COMMON dependencies on FND_MENUS

Line 978: fnd_menus fmu,

974: IS
975: SELECT DISTINCT fgs.instance_pk1_value resource_id,
976: fgs.instance_pk2_value resource_type
977: FROM fnd_grants fgs,
978: fnd_menus fmu,
979: fnd_objects fos,
980: jtf_rs_group_usages jru,
981: jtf_rs_groups_tl jrt
982: WHERE fgs.object_id = fos.object_id -- grants joint to object

Line 2017: FROM fnd_menus fmu, fnd_objects fos, fnd_grants fgs

2013: -- 3) JTF_CAL_READ_ACCESS
2014: CURSOR c_access (b_group_id VARCHAR2, b_resource_id VARCHAR2)
2015: IS
2016: SELECT DISTINCT fmu.menu_name
2017: FROM fnd_menus fmu, fnd_objects fos, fnd_grants fgs
2018: WHERE fmu.menu_id = fgs.menu_id -- grants joint to menus
2019: AND fos.obj_name = 'JTF_TASK_RESOURCE'
2020: AND fos.object_id = fgs.object_id -- grants joint to object
2021: AND fgs.grantee_key = b_resource_id

Line 2029: l_menu_name fnd_menus.menu_name%TYPE;

2025: OR fgs.end_date IS NULL)
2026: AND fgs.instance_pk2_value = 'RS_GROUP'
2027: AND fgs.instance_pk1_value = b_group_id;
2028:
2029: l_menu_name fnd_menus.menu_name%TYPE;
2030: BEGIN
2031: OPEN c_access (b_group_id => p_group_id, b_resource_id => p_resource_id);
2032: FETCH c_access into l_menu_name;
2033: