APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on FND_USER

Line 63: 05-Aug-2005 raluthra Bug 4527617. Replaced fnd_user.customer_id with

59: 07-Feb-2005 rvelusam Bug : 4165764
60: In the procedure set_report_approver added new variable
61: l_approver_name. And changed to code to set the correct
62: 'To' field value.
63: 05-Aug-2005 raluthra Bug 4527617. Replaced fnd_user.customer_id with
64: fnd_user.person_party_id for R12 ATG Mandate fix.
65: 09-Feb-2006 posingha Bug 4530998. Changed the l_org variable from VARCHAR(60) to
66: pa_project_lists_v.carrying_out_organization_name%TYPE to allow
67: longer organization names to be accepted.

Line 64: fnd_user.person_party_id for R12 ATG Mandate fix.

60: In the procedure set_report_approver added new variable
61: l_approver_name. And changed to code to set the correct
62: 'To' field value.
63: 05-Aug-2005 raluthra Bug 4527617. Replaced fnd_user.customer_id with
64: fnd_user.person_party_id for R12 ATG Mandate fix.
65: 09-Feb-2006 posingha Bug 4530998. Changed the l_org variable from VARCHAR(60) to
66: pa_project_lists_v.carrying_out_organization_name%TYPE to allow
67: longer organization names to be accepted.
68: 31-Mar-2006 posingha Bug 5027098, Added code to set the 'From' role attribute

Line 365: per_all_people_f papf, fnd_user fu

361: CURSOR get_user_name_csr (l_usr_id number)
362: IS
363: SELECT fu.user_name
364: from
365: per_all_people_f papf, fnd_user fu
366: WHERE
367: fu.user_id = l_usr_id
368: and
369: fu.employee_id = papf.person_id;

Line 375: fnd_user usr

371:
372: CURSOR c_submitter_list IS
373: select UNIQUE usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
374: from per_all_people_f papf,
375: fnd_user usr
376: WHERE
377: papf.person_id = usr.employee_id
378: and trunc(sysdate)
379: between papf.EFFECTIVE_START_DATE

Line 388: fnd_user usr,

384: CURSOR c_reporter_list IS
385: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
386: usr.user_name,papf.email_address,papf.full_name person_name
387: from per_all_people_f papf,
388: fnd_user usr,
389: pa_project_parties ppp
390: WHERE
391: papf.person_id = usr.employee_id
392: and trunc(sysdate)

Line 855: FROM fnd_user

851: l_count NUMBER := 1; /*bug 5716959*/
852: CURSOR get_user_name
853: IS
854: SELECT user_name
855: FROM fnd_user
856: WHERE user_id = FND_GLOBAL.user_id;
857:
858: CURSOR l_report_approver_csr_person IS
859: select distinct

Line 865: fnd_user fu,per_all_people_f papf

861: fu.user_name,
862: papf.email_address,
863: papf.full_name person_name
864: from
865: fnd_user fu,per_all_people_f papf
866: where
867: fu.employee_id = l_approver_id
868: and papf.person_id = fu.employee_id
869: and trunc(sysdate)

Line 882: fnd_user fu,per_all_people_f papf

878: fu.user_name,
879: papf.email_address,
880: papf.full_name person_name
881: from
882: fnd_user fu,per_all_people_f papf
883: where
884: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
885: and papf.person_id = fu.employee_id
886: and trunc(sysdate)

Line 909: , fnd_user fu

905: SELECT DISTINCT
906: fu.user_name,
907: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
908: FROM per_assignments_f p1, per_all_people_f p2
909: , fnd_user fu
910: WHERE p1.person_id = l_reported_by_id
911: and p1.supervisor_id = p2.person_id
912: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451
913: AND p1.primary_flag ='Y' -- Added for bug 2911451

Line 1184: fnd_user usr

1180: SELECT
1181: usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
1182: FROM pa_project_lists_v pplv,
1183: per_all_people_f papf,
1184: fnd_user usr
1185: WHERE pplv.project_id = l_project_id
1186: and papf.person_id = usr.employee_id
1187: and trunc(sysdate)
1188: between papf.EFFECTIVE_START_DATE