DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_OBJECTS

Line 931: fnd_objects obj

927: granted_menu.menu_id menu_id,
928: grants.end_date end_date
929: FROM fnd_grants grants,
930: fnd_menus granted_menu,
931: fnd_objects obj
932: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
933: AND grants.object_id = obj.object_id
934: AND grants.grantee_type ='USER'
935: AND grantee_key like 'HZ_PARTY%'

Line 7050: fnd_objects obj

7046: granted_menu.menu_id menu_id,
7047: grants.end_date end_date
7048: FROM fnd_grants grants,
7049: fnd_menus granted_menu,
7050: fnd_objects obj
7051: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7052: AND grants.object_id = obj.object_id
7053: AND grants.grantee_type ='USER'
7054: AND grantee_key like 'HZ_PARTY%'

Line 7071: fnd_objects obj

7067: cursor org_only_party_list(org_id number, process_id number, org_menu_name varchar2, rl_menu_name varchar2) is
7068: SELECT grants.grant_guid grant_guid
7069: FROM fnd_grants grants,
7070: fnd_menus granted_menu,
7071: fnd_objects obj
7072: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7073: AND grants.object_id = obj.object_id
7074: AND grants.grantee_type ='USER'
7075: AND grantee_key like 'HZ_PARTY%'

Line 7092: fnd_objects obj

7088: and granted_menu.menu_name = org_menu_name
7089: and (grants.grantee_key, obj.object_id ,grants.menu_id ) not in (select grants.grantee_key,obj.object_id, grants.menu_id
7090: FROM fnd_grants grants,
7091: fnd_menus granted_menu,
7092: fnd_objects obj
7093: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7094: AND grants.object_id = obj.object_id
7095: AND grants.grantee_type ='USER'
7096: AND grantee_key like 'HZ_PARTY%'

Line 7274: fnd_objects obj

7270: SELECT grants.grant_guid grant_guid
7271: BULK COLLECT INTO l_grant_guid
7272: FROM fnd_grants grants,
7273: fnd_menus granted_menu,
7274: fnd_objects obj
7275: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7276: AND grants.object_id = obj.object_id
7277: AND grants.grantee_type ='USER'
7278: AND grantee_key like 'HZ_PARTY%'

Line 7291: fnd_objects obj

7287: and granted_menu.menu_name = p_org_menu_name
7288: and (grants.grantee_key) not in ( select grants.grantee_key
7289: FROM fnd_grants grants,
7290: fnd_menus granted_menu,
7291: fnd_objects obj
7292: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7293: AND grants.object_id = obj.object_id
7294: AND grants.grantee_type ='USER'
7295: AND grantee_key like 'HZ_PARTY%'

Line 7364: fnd_objects obj

7360: BULK COLLECT INTO l_party_id,
7361: l_end_date
7362: FROM fnd_grants grants,
7363: fnd_menus granted_menu,
7364: fnd_objects obj
7365: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7366: AND grants.object_id = obj.object_id
7367: AND grants.grantee_type ='USER'
7368: AND grantee_key like 'HZ_PARTY%'

Line 7381: fnd_objects obj

7377: and granted_menu.menu_name = p_rl_menu_name
7378: and (grants.grantee_key) not in ( select grants.grantee_key
7379: FROM fnd_grants grants,
7380: fnd_menus granted_menu,
7381: fnd_objects obj
7382: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7383: AND grants.object_id = obj.object_id
7384: AND grants.grantee_type ='USER'
7385: AND grantee_key like 'HZ_PARTY%'