298: (
299: select hp.party_id
300: from fnd_user fu,
301: hz_parties hp
302: where fu.user_id = fnd_global.user_id
303: and fu.employee_id is null
304: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
305: union
306: select hp.party_id
305: union
306: select hp.party_id
307: from fnd_user fu,
308: hz_parties hp
309: where fu.user_id = fnd_global.user_id
310: and fu.employee_id is not null
311: and 'PER:' || fu.employee_id = hp.orig_system_reference);
312:
313: CURSOR get_ci_info
617: CURSOR get_user_name
618: IS
619: SELECT user_name
620: FROM fnd_user
621: WHERE user_id = FND_GLOBAL.user_id;
622:
623:
624: CURSOR get_approver_list
625: IS