APPS.ENGECOBO dependencies on FND_GRANTS

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

4242:
4243: /* Cursor to fetch the assignees with direct item roles at item level */
4244: CURSOR c_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4245: SELECT party.party_id, party.party_name, party.party_type
4246: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4247: WHERE obj.obj_name = 'EGO_ITEM'
4248: AND grants.object_id = obj.object_id
4249: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4250: AND (

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

4261:
4262: /* Cursor to fetch the assignees with item roles at catalog category level */
4263: CURSOR c_category_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4264: SELECT party.party_id, party.party_name, party.party_type
4265: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4266: WHERE obj.obj_name = 'EGO_ITEM'
4267: AND grants.object_id = obj.object_id
4268: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4269: AND (

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

4285:
4286: /* Cursor to fetch the assignees with item roles at organization level */
4287: CURSOR c_org_assignee(cp_assignee_role_id NUMBER, cp_org_id NUMBER) IS
4288: SELECT party.party_id, party.party_name, party.party_type
4289: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4290: WHERE obj.obj_name = 'EGO_ITEM'
4291: AND grants.object_id = obj.object_id
4292: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4293: AND (