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 373: per_all_people_f papf, fnd_user fu

369: CURSOR get_user_name_csr (l_usr_id number)
370: IS
371: SELECT fu.user_name
372: from
373: per_all_people_f papf, fnd_user fu
374: WHERE
375: fu.user_id = l_usr_id
376: and
377: fu.employee_id = papf.person_id;

Line 383: fnd_user usr

379:
380: CURSOR c_submitter_list IS
381: 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.
382: from per_all_people_f papf,
383: fnd_user usr
384: WHERE
385: papf.person_id = usr.employee_id
386: and trunc(sysdate)
387: between papf.EFFECTIVE_START_DATE

Line 396: fnd_user usr,

392: CURSOR c_reporter_list IS
393: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
394: usr.user_name,papf.email_address,papf.full_name person_name
395: from per_all_people_f papf,
396: fnd_user usr,
397: pa_project_parties ppp
398: WHERE
399: papf.person_id = usr.employee_id
400: and trunc(sysdate)

Line 883: FROM fnd_user

879: l_count NUMBER := 1; /*bug 5716959*/
880: CURSOR get_user_name
881: IS
882: SELECT user_name
883: FROM fnd_user
884: WHERE user_id = FND_GLOBAL.user_id;
885:
886: CURSOR l_report_approver_csr_person IS
887: select distinct

Line 893: fnd_user fu,per_all_people_f papf

889: fu.user_name,
890: papf.email_address,
891: papf.full_name person_name
892: from
893: fnd_user fu,per_all_people_f papf
894: where
895: fu.employee_id = l_approver_id
896: and papf.person_id = fu.employee_id
897: and trunc(sysdate)

Line 910: fnd_user fu,per_all_people_f papf

906: fu.user_name,
907: papf.email_address,
908: papf.full_name person_name
909: from
910: fnd_user fu,per_all_people_f papf
911: where
912: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
913: and papf.person_id = fu.employee_id
914: and trunc(sysdate)

Line 937: , fnd_user fu

933: SELECT DISTINCT
934: fu.user_name,
935: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
936: FROM per_assignments_f p1, per_all_people_f p2
937: , fnd_user fu
938: WHERE p1.person_id = l_reported_by_id
939: and p1.supervisor_id = p2.person_id
940: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451
941: AND p1.primary_flag ='Y' -- Added for bug 2911451

Line 1234: fnd_user usr

1230: SELECT
1231: 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.
1232: FROM pa_project_lists_v pplv,
1233: per_all_people_f papf,
1234: fnd_user usr
1235: WHERE pplv.project_id = l_project_id
1236: and papf.person_id = usr.employee_id
1237: and trunc(sysdate)
1238: between papf.EFFECTIVE_START_DATE