DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on FND_GLOBAL

Line 298: where fu.user_id = fnd_global.user_id

294: (
295: select hp.party_id
296: from fnd_user fu,
297: hz_parties hp
298: where fu.user_id = fnd_global.user_id
299: and fu.employee_id is null
300: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
301: union
302: select hp.party_id

Line 305: where fu.user_id = fnd_global.user_id

301: union
302: select hp.party_id
303: from fnd_user fu,
304: hz_parties hp
305: where fu.user_id = fnd_global.user_id
306: and fu.employee_id is not null
307: and 'PER:' || fu.employee_id = hp.orig_system_reference);
308:
309: CURSOR get_ci_info

Line 616: WHERE user_id = FND_GLOBAL.user_id;

612: CURSOR get_user_name
613: IS
614: SELECT user_name
615: FROM fnd_user
616: WHERE user_id = FND_GLOBAL.user_id;
617:
618:
619: CURSOR get_approver_list
620: IS