DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on FND_MENUS_TL

Line 13958: fnd_menus_tl tl,

13954: v_assignee_type IN VARCHAR)
13955: IS
13956: SELECT fg.grantee_orig_system_id
13957: FROM fnd_grants fg,
13958: fnd_menus_tl tl,
13959: fnd_menus m,
13960: (SELECT distinct f.object_id,
13961: e.menu_id
13962: FROM fnd_form_functions f,

Line 16797: fnd_menus_tl menutl

16793: FROM fnd_grants grants,
16794: hz_parties grantee_global,
16795: fnd_menus granted_menu,
16796: fnd_objects obj,
16797: fnd_menus_tl menutl
16798: WHERE obj.obj_name = 'EGO_ITEM'
16799: AND grants.object_id = obj.object_id
16800: AND grants.grantee_type = 'GLOBAL'
16801: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 16842: fnd_menus_tl menutl

16838: FROM fnd_grants grants,
16839: hz_parties grantee_global,
16840: fnd_menus granted_menu,
16841: fnd_objects obj,
16842: fnd_menus_tl menutl
16843: WHERE obj.obj_name = 'EGO_ITEM'
16844: AND grants.object_id = obj.object_id
16845: AND grants.grantee_type = 'GLOBAL'
16846: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 16883: fnd_menus_tl menutl

16879: FROM fnd_grants grants,
16880: ego_groups_v grantee_group,
16881: fnd_menus granted_menu,
16882: fnd_objects obj,
16883: fnd_menus_tl menutl
16884: WHERE obj.obj_name = 'EGO_ITEM'
16885: AND grants.object_id = obj.object_id
16886: AND grants.grantee_type = 'GROUP'
16887: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_GROUP:', '')) =

Line 16930: fnd_menus_tl menutl

16926: FROM fnd_grants grants,
16927: ego_groups_v grantee_group,
16928: fnd_menus granted_menu,
16929: fnd_objects obj,
16930: fnd_menus_tl menutl
16931: WHERE obj.obj_name = 'EGO_ITEM'
16932: AND grants.object_id = obj.object_id
16933: AND grants.grantee_type = 'GROUP'
16934: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_GROUP:', '')) =

Line 16973: fnd_menus_tl menutl

16969: FROM fnd_grants grants,
16970: ego_person_company_v grantee_person,
16971: fnd_menus granted_menu,
16972: fnd_objects obj,
16973: fnd_menus_tl menutl
16974: WHERE obj.obj_name = 'EGO_ITEM'
16975: AND grants.object_id = obj.object_id
16976: AND grants.grantee_type = 'USER'
16977: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) =

Line 17020: fnd_menus_tl menutl

17016: FROM fnd_grants grants,
17017: ego_person_company_v grantee_person,
17018: fnd_menus granted_menu,
17019: fnd_objects obj,
17020: fnd_menus_tl menutl
17021: WHERE obj.obj_name = 'EGO_ITEM'
17022: AND grants.object_id = obj.object_id
17023: AND grants.grantee_type = 'USER'
17024: AND TO_NUMBER(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) =

Line 17063: fnd_menus_tl menutl

17059: FROM fnd_grants grants,
17060: ego_companies_v grantee_company,
17061: fnd_menus granted_menu,
17062: fnd_objects obj,
17063: fnd_menus_tl menutl
17064: WHERE obj.obj_name = 'EGO_ITEM'
17065: AND grants.object_id = obj.object_id
17066: AND grants.grantee_type = 'COMPANY'
17067: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)

Line 17110: fnd_menus_tl menutl

17106: FROM fnd_grants grants,
17107: ego_companies_v grantee_company,
17108: fnd_menus granted_menu,
17109: fnd_objects obj,
17110: fnd_menus_tl menutl
17111: WHERE obj.obj_name = 'EGO_ITEM'
17112: AND grants.object_id = obj.object_id
17113: AND grants.grantee_type = 'COMPANY'
17114: AND NVL(grants.end_date, SYSDATE + 1) >= TRUNC(SYSDATE)