APPS.ENGECOBO dependencies on FND_USER

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