eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on FND_USER

Line 90: from per_all_people_f papf, fnd_user usr

86: /*
87: CURSOR getSubmitter IS
88: select usr.user_id, usr.customer_id, usr.user_name, papf.email_address,
89: papf.full_name person_name
90: from per_all_people_f papf, fnd_user usr
91: where papf.person_id = usr.employee_id
92: and trunc(sysdate) between papf.effective_start_date
93: and nvl(papf.effective_end_date, sysdate+1)
94: and trunc(sysdate) between usr.start_date

Line 103: FROM per_all_people_f papf, fnd_user usr

99: -- Bug 6826760 - Replaced l_locked_by_person_id with p_user_id.
100: CURSOR getSubmitter IS
101: SELECT usr.user_id, usr.person_party_id, usr.user_name, papf.email_address, --customer_id is replaced with person_party_id
102: papf.full_name person_name
103: FROM per_all_people_f papf, fnd_user usr
104: WHERE papf.person_id = usr.employee_id
105: AND trunc(sysdate) between papf.effective_start_date
106: AND nvl(papf.effective_end_date, sysdate+1)
107: AND trunc(sysdate) between usr.start_date

Line 291: fnd_user fu, pa_project_parties p

287: CURSOR getProjectManagerHR IS
288: select fu.user_name, p1.supervisor_id person_id, p2.full_name person_name,
289: p2.email_address
290: from per_assignments_f p1, per_all_people_f p2,
291: fnd_user fu, pa_project_parties p
292: where p.project_id = l_project_id
293: and p.project_role_id = 1
294: and TRUNC(sysdate) between p.START_DATE_ACTIVE
295: and NVL(p.END_DATE_ACTIVE, sysdate+1)

Line 310: from fnd_user fu, per_all_people_f papf

306:
307: CURSOR l_approver_csr_person IS
308: select distinct fu.user_id, fu.user_name, papf.email_address,
309: papf.full_name person_name
310: from fnd_user fu, per_all_people_f papf
311: where fu.employee_id = l_source_id
312: and papf.person_id = fu.employee_id
313: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
314: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 322: from fnd_user fu,per_all_people_f papf

318: /*
319: CURSOR l_approver_csr_party IS
320: select distinct fu.user_id, fu.user_name, papf.email_address,
321: papf.full_name person_name
322: from fnd_user fu,per_all_people_f papf
323: where fu.customer_id = l_source_id
324: and papf.person_id = fu.employee_id
325: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
326: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 333: from fnd_user fu,per_all_people_f papf

329: */
330: CURSOR l_approver_csr_party IS
331: select distinct fu.user_id, fu.user_name, papf.email_address,
332: papf.full_name person_name
333: from fnd_user fu,per_all_people_f papf
334: where fu.person_party_id = l_source_id --reference is changed from customer_id to person_party_id
335: and papf.person_id = fu.employee_id
336: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
337: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 523: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

519: --This cursor returns internal users.
520: CURSOR getApprovedRejectedPerson IS
521: select distinct fu.user_id, fu.user_name, papf.email_address,
522: papf.full_name person_name
523: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
524: pa_project_role_types pprt
525: where object_type = 'PA_PROJECTS'
526: --and object_id = l_project_id Bug 4562762
527: -- Bug 4562762 : Added logic to select program too

Line 554: from fnd_user fu, per_all_people_f papf

550: and f2.function_id = f1.function_id)
551: UNION /*Added this clause for Approver 4291185 */
552: select distinct fu.user_id, fu.user_name, papf.email_address,
553: papf.full_name person_name
554: from fnd_user fu, per_all_people_f papf
555: where fu.user_id = fnd_global.USER_ID
556: and papf.person_id = fu.employee_id
557: and trunc(sysdate) between papf.effective_start_date
558: and nvl(papf.effective_end_date, sysdate+1)

Line 570: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

566: /*
567: CURSOR getApprovedRejectedParty IS
568: select distinct fu.user_id, fu.user_name, papf.email_address,
569: papf.full_name person_name
570: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
571: pa_project_role_types pprt
572: where object_type = 'PA_PROJECTS'
573: and object_id = l_project_id
574: and ppp.resource_type_id = 112

Line 593: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

589:
590: CURSOR getApprovedRejectedParty IS
591: select distinct fu.user_id, fu.user_name, papf.email_address,
592: papf.full_name person_name
593: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
594: pa_project_role_types pprt
595: where object_type = 'PA_PROJECTS'
596: and object_id = l_project_id
597: and ppp.resource_type_id = 112

Line 622: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

618: --Bug No 3695601 Performance Fix Using EXISTS instead of IN
619: /* CURSOR getWorkplanViewerPerson IS
620: select distinct fu.user_id, fu.user_name, papf.email_address,
621: papf.full_name person_name
622: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
623: pa_project_role_types pprt
624: where object_type = 'PA_PROJECTS'
625: and object_id = l_project_id
626: and ppp.resource_type_id = 101

Line 644: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele

640: and f2.function_id = f1.function_id)
641: UNION
642: select distinct fu.user_id, fu.user_name, papf.email_address,
643: papf.full_name person_name
644: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
645: where ele.project_id = l_project_id
646: and ele.MANAGER_PERSON_ID = fu.employee_id
647: and papf.person_id = fu.employee_id
648: and trunc(sysdate) between papf.effective_start_date

Line 656: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

652:
653: CURSOR getWorkplanViewerPerson IS
654: select distinct fu.user_id, fu.user_name, papf.email_address,
655: papf.full_name person_name
656: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
657: pa_project_role_types pprt
658: where object_type = 'PA_PROJECTS'
659: and object_id = l_project_id
660: and ppp.resource_type_id = 101

Line 678: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele

674: and f2.function_id = f1.function_id)
675: UNION
676: select distinct fu.user_id, fu.user_name, papf.email_address,
677: papf.full_name person_name
678: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
679: where ele.project_id = l_project_id
680: and ele.MANAGER_PERSON_ID = fu.employee_id
681: and papf.person_id = fu.employee_id
682: and trunc(sysdate) between papf.effective_start_date

Line 689: from fnd_user fu, per_all_people_f papf

685: and nvl(fu.end_date, sysdate+1)
686: UNION
687: select distinct fu.user_id, fu.user_name, papf.email_address,
688: papf.full_name person_name
689: from fnd_user fu, per_all_people_f papf
690: where fu.user_id = fnd_global.USER_ID
691: and papf.person_id = fu.employee_id
692: and trunc(sysdate) between papf.effective_start_date
693: and nvl(papf.effective_end_date, sysdate+1)

Line 701: -- 4586987 customer_id changed to person_party_id in fnd_user table

697:
698: --This cursor is used when the workplan is published.
699: --This cursor returns all project members who has the view privilege.
700: --This cursor returns external users or companies.
701: -- 4586987 customer_id changed to person_party_id in fnd_user table
702: /*
703: CURSOR getWorkplanViewerParty IS
704: select distinct fu.user_id, fu.user_name, papf.email_address,
705: papf.full_name person_name

Line 706: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

702: /*
703: CURSOR getWorkplanViewerParty IS
704: select distinct fu.user_id, fu.user_name, papf.email_address,
705: papf.full_name person_name
706: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
707: pa_project_role_types pprt
708: where object_type = 'PA_PROJECTS'
709: and object_id = l_project_id
710: and ppp.resource_type_id = 112

Line 730: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

726:
727: CURSOR getWorkplanViewerParty IS
728: select distinct fu.user_id, fu.user_name, papf.email_address,
729: papf.full_name person_name
730: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
731: pa_project_role_types pprt
732: where object_type = 'PA_PROJECTS'
733: and object_id = l_project_id
734: and ppp.resource_type_id = 112

Line 736: and ppp.resource_id = fu.person_party_id -- customer_id changed to person_party_id in fnd_user table

732: where object_type = 'PA_PROJECTS'
733: and object_id = l_project_id
734: and ppp.resource_type_id = 112
735: and ppp.project_role_id = pprt.project_role_id
736: and ppp.resource_id = fu.person_party_id -- customer_id changed to person_party_id in fnd_user table
737: and papf.person_id = fu.employee_id
738: and trunc(sysdate) between papf.effective_start_date
739: and nvl(papf.effective_end_date, sysdate+1)
740: and trunc(sysdate) between fu.start_date