DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on FND_GLOBAL

Line 302: where fu.user_id = fnd_global.user_id

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

Line 309: where fu.user_id = fnd_global.user_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

Line 621: WHERE user_id = FND_GLOBAL.user_id;

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