APPS.ENGECOBO dependencies on FND_USER

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 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