APPS.ENGECOBO dependencies on HZ_PARTIES

Line 1922: SELECT us.user_name FROM fnd_user us, hz_parties pa

1918: -- Modified query for performance bug 4251776
1919: -- Bug No: 4327218
1920: -- Modified query to refer to 'person_party_id' instead of 'customer_id'
1921: CURSOR c_user_name(v_party_id IN NUMBER) IS
1922: SELECT us.user_name FROM fnd_user us, hz_parties pa
1923: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
1924: AND pa.party_id = v_party_id
1925: union all
1926: SELECT us.user_name

Line 1927: FROM fnd_user us, hz_parties pa

1923: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
1924: AND pa.party_id = v_party_id
1925: union all
1926: SELECT us.user_name
1927: FROM fnd_user us, hz_parties pa
1928: WHERE (us.employee_id IS NULL AND (us.person_party_id= pa.party_id or (us.person_party_id is null and us.supplier_id = pa.party_id)))
1929: AND pa.party_id = v_party_id;
1930:
1931: /* WHERE nvl(us.employee_id, nvl(us.customer_id, us.supplier_id)) = pa.person_identifier

Line 4239: FROM hz_parties

4235: AND nvl(start_date, sysdate) > sysdate; -- Added this condtion as only future revisions need to be fetched
4236: /* Cursor to fetch the group name given the party id */
4237: CURSOR c_group_name(cp_party_id NUMBER) IS
4238: SELECT party_name
4239: FROM hz_parties
4240: WHERE party_id = cp_party_id
4241: AND party_type = 'GROUP';
4242:
4243: /* Cursor to fetch the assignees with direct item roles at item level */

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 (

Line 4310: SELECT us.user_name FROM fnd_user us, hz_parties pa

4306:
4307: -- Bug No: 4327218
4308: -- Modified query to refer to 'person_party_id' instead of 'customer_id'
4309: CURSOR c_user_name(v_party_id IN NUMBER) IS
4310: SELECT us.user_name FROM fnd_user us, hz_parties pa
4311: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
4312: AND pa.party_id = v_party_id
4313: union all
4314: SELECT us.user_name

Line 4315: FROM fnd_user us, hz_parties pa

4311: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
4312: AND pa.party_id = v_party_id
4313: union all
4314: SELECT us.user_name
4315: FROM fnd_user us, hz_parties pa
4316: WHERE (us.employee_id IS NULL AND (us.person_party_id = pa.party_id or (us.person_party_id is null and us.supplier_id = pa.party_id)))
4317: AND pa.party_id = v_party_id;
4318:
4319: BEGIN