APPS.ENGECOBO dependencies on FND_GRANTS

Line 4121: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj

4117:
4118: /* Cursor to fetch the assignees with direct item roles at item level */
4119: CURSOR c_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4120: SELECT party.party_id, party.party_name, party.party_type
4121: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4122: WHERE obj.obj_name = 'EGO_ITEM'
4123: AND grants.object_id = obj.object_id
4124: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4125: AND (

Line 4140: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj

4136:
4137: /* Cursor to fetch the assignees with item roles at catalog category level */
4138: CURSOR c_category_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4139: SELECT party.party_id, party.party_name, party.party_type
4140: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4141: WHERE obj.obj_name = 'EGO_ITEM'
4142: AND grants.object_id = obj.object_id
4143: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4144: AND (

Line 4164: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj

4160:
4161: /* Cursor to fetch the assignees with item roles at organization level */
4162: CURSOR c_org_assignee(cp_assignee_role_id NUMBER, cp_org_id NUMBER) IS
4163: SELECT party.party_id, party.party_name, party.party_type
4164: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4165: WHERE obj.obj_name = 'EGO_ITEM'
4166: AND grants.object_id = obj.object_id
4167: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4168: AND (