DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on FND_GRANTS

Line 13957: FROM fnd_grants fg,

13953: CURSOR c_role_assignee (v_assignee_id IN NUMBER,
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

Line 16793: FROM fnd_grants grants,

16789: grants.instance_pk5_value pk5_value,
16790: grants.instance_set_id instance_set_id,
16791: grants.ROWID as row_id,
16792: LTRIM(grantee_global.party_name, '* ') as decoded_party_name
16793: FROM fnd_grants grants,
16794: hz_parties grantee_global,
16795: fnd_menus granted_menu,
16796: fnd_objects obj,
16797: fnd_menus_tl menutl

Line 16838: FROM fnd_grants grants,

16834: grants.instance_pk5_value pk5_value,
16835: grants.instance_set_id instance_set_id,
16836: grants.ROWID as row_id,
16837: LTRIM(grantee_global.party_name, '* ') as decoded_party_name
16838: FROM fnd_grants grants,
16839: hz_parties grantee_global,
16840: fnd_menus granted_menu,
16841: fnd_objects obj,
16842: fnd_menus_tl menutl

Line 16879: FROM fnd_grants grants,

16875: grants.instance_pk5_value pk5_value,
16876: grants.instance_set_id instance_set_id,
16877: grants.ROWID as row_id,
16878: grantee_group.group_name as decoded_party_name
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

Line 16926: FROM fnd_grants grants,

16922: grants.instance_pk5_value pk5_value,
16923: grants.instance_set_id instance_set_id,
16924: grants.ROWID as row_id,
16925: grantee_group.group_name decoded_party_name
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

Line 16969: FROM fnd_grants grants,

16965: grants.instance_pk5_value pk5_value,
16966: grants.instance_set_id instance_set_id,
16967: grants.ROWID as row_id,
16968: LTRIM(grantee_person.person_name, '* ') as decoded_party_name
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

Line 17016: FROM fnd_grants grants,

17012: grants.instance_pk5_value pk5_value,
17013: grants.instance_set_id instance_set_id,
17014: grants.ROWID as row_id,
17015: LTRIM(grantee_person.person_name, '* ') as decoded_party_name
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

Line 17059: FROM fnd_grants grants,

17055: grants.instance_pk5_value pk5_value,
17056: grants.instance_set_id instance_set_id,
17057: grants.ROWID as row_id,
17058: grantee_company.company_name decoded_party_name
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

Line 17106: FROM fnd_grants grants,

17102: grants.instance_pk5_value pk5_value,
17103: grants.instance_set_id instance_set_id,
17104: grants.ROWID as row_id,
17105: grantee_company.company_name decoded_party_name
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