APPS.ENGECOBO dependencies on HZ_PARTIES

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

1899: -- Modified query for performance bug 4251776
1900: -- Bug No: 4327218
1901: -- Modified query to refer to 'person_party_id' instead of 'customer_id'
1902: CURSOR c_user_name(v_party_id IN NUMBER) IS
1903: SELECT us.user_name FROM fnd_user us, hz_parties pa
1904: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
1905: AND pa.party_id = v_party_id
1906: union all
1907: SELECT us.user_name

Line 1908: FROM fnd_user us, hz_parties pa

1904: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
1905: AND pa.party_id = v_party_id
1906: union all
1907: SELECT us.user_name
1908: FROM fnd_user us, hz_parties pa
1909: 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)))
1910: AND pa.party_id = v_party_id;
1911:
1912: /* WHERE nvl(us.employee_id, nvl(us.customer_id, us.supplier_id)) = pa.person_identifier

Line 4114: FROM hz_parties

4110: AND nvl(start_date, sysdate) > sysdate; -- Added this condtion as only future revisions need to be fetched
4111: /* Cursor to fetch the group name given the party id */
4112: CURSOR c_group_name(cp_party_id NUMBER) IS
4113: SELECT party_name
4114: FROM hz_parties
4115: WHERE party_id = cp_party_id
4116: AND party_type = 'GROUP';
4117:
4118: /* Cursor to fetch the assignees with direct item roles at item level */

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 (

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

4181:
4182: -- Bug No: 4327218
4183: -- Modified query to refer to 'person_party_id' instead of 'customer_id'
4184: CURSOR c_user_name(v_party_id IN NUMBER) IS
4185: SELECT us.user_name FROM fnd_user us, hz_parties pa
4186: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
4187: AND pa.party_id = v_party_id
4188: union all
4189: SELECT us.user_name

Line 4190: FROM fnd_user us, hz_parties pa

4186: WHERE ((us.employee_id IS NOT NULL AND us.employee_id = pa.person_identifier))
4187: AND pa.party_id = v_party_id
4188: union all
4189: SELECT us.user_name
4190: FROM fnd_user us, hz_parties pa
4191: 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)))
4192: AND pa.party_id = v_party_id;
4193:
4194: BEGIN