APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on FND_USER

Line 52: 08/03/05 raluthra Bug 4527617. Replaced the usage of fnd_user.

48: HISTORY : 07/22/02 SYAO Initial Creation
49: 08/18/04 mumohan Bug#3838957: Added the condition to exclude
50: the end dated users in the cursors
51: get_approver_list and get_notification_list.
52: 08/03/05 raluthra Bug 4527617. Replaced the usage of fnd_user.
53: customer_id with fnd_user.person_party_id
54: for R12 ATG Mandate.
55: 08/05/05 raluthra Bug 4358517: Changed the definition of
56: l_org local variable from VARCHAR2(60) to

Line 53: customer_id with fnd_user.person_party_id

49: 08/18/04 mumohan Bug#3838957: Added the condition to exclude
50: the end dated users in the cursors
51: get_approver_list and get_notification_list.
52: 08/03/05 raluthra Bug 4527617. Replaced the usage of fnd_user.
53: customer_id with fnd_user.person_party_id
54: for R12 ATG Mandate.
55: 08/05/05 raluthra Bug 4358517: Changed the definition of
56: l_org local variable from VARCHAR2(60) to
57: pa_project_lists_v.carrying_out_organization_name%TYPE

Line 296: from fnd_user fu,

292: IS
293: select party_id from
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.

Line 303: from fnd_user fu,

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

Line 615: FROM fnd_user

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

Line 624: from fnd_user fu,

620: IS
621: select user_name, party_name, email_address
622: from (
623: select fu.user_name, hp.party_name, hp.email_address
624: from fnd_user fu,
625: hz_parties hp
626: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
627: and hp.party_id = l_proj_mgr_id
628: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */

Line 631: from fnd_user fu,

627: and hp.party_id = l_proj_mgr_id
628: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
629: union
630: select fu.user_name, hp.party_name, hp.email_address
631: from fnd_user fu,
632: hz_parties hp,
633: per_all_people_f papf
634: where
635: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))

Line 829: from fnd_user fu,

825: IS
826: select user_name, party_name, email_address
827: from (
828: select fu.user_name, hp.party_name, hp.email_address
829: from fnd_user fu,
830: hz_parties hp
831: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
832: and hp.party_id = l_owner_id
833: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */

Line 836: from fnd_user fu,

832: and hp.party_id = l_owner_id
833: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
834: union
835: select fu.user_name, hp.party_name, hp.email_address
836: from fnd_user fu,
837: hz_parties hp,
838: per_all_people_f papf
839: where
840: --'PER:' || fu.employee_id = hp.orig_system_reference