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 PER_ALL_PEOPLE_F

Line 61: l_submitter_name per_all_people_f.full_name%type; -- Added for bug# 7368606

57: l_project_num VARCHAR2(25);
58: l_record_version_num NUMBER;
59: l_submitter_role VARCHAR2(30);
60: l_submitter_role_users VARCHAR2(300);
61: l_submitter_name per_all_people_f.full_name%type; -- Added for bug# 7368606
62:
63:
64: display_name VARCHAR2(2000);
65: email_address VARCHAR2(2000);

Line 93: from per_all_people_f papf, fnd_user usr

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

Line 106: FROM per_all_people_f papf, fnd_user usr

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

Line 289: from pa_proj_workplan_attr wp, per_all_people_f p1

285: where project_id = l_project_id; */
286:
287: CURSOR getApprover IS
288: select wp.wp_approver_source_id, wp.wp_approver_source_type, p1.full_name
289: from pa_proj_workplan_attr wp, per_all_people_f p1
290: where wp.project_id = l_project_id
291: and p1.person_id = wp.wp_approver_source_id
292: and trunc(sysdate) between trunc(p1.effective_start_date)
293: and NVL(p1.effective_end_date, sysdate);

Line 301: from per_assignments_f p1, per_all_people_f p2,

297: the approver is not specified */
298: CURSOR getProjectManagerHR IS
299: select fu.user_name, p1.supervisor_id person_id, p2.full_name person_name,
300: p2.email_address
301: from per_assignments_f p1, per_all_people_f p2,
302: fnd_user fu, pa_project_parties p
303: where p.project_id = l_project_id
304: and p.project_role_id = 1
305: and TRUNC(sysdate) between p.START_DATE_ACTIVE

Line 321: from fnd_user fu, per_all_people_f papf

317:
318: CURSOR l_approver_csr_person IS
319: select distinct fu.user_id, fu.user_name, papf.email_address,
320: papf.full_name person_name
321: from fnd_user fu, per_all_people_f papf
322: where fu.employee_id = l_source_id
323: and papf.person_id = fu.employee_id
324: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
325: 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.customer_id = l_source_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 344: from fnd_user fu,per_all_people_f papf

340: */
341: CURSOR l_approver_csr_party IS
342: select distinct fu.user_id, fu.user_name, papf.email_address,
343: papf.full_name person_name
344: from fnd_user fu,per_all_people_f papf
345: where fu.person_party_id = l_source_id --reference is changed from customer_id to person_party_id
346: and papf.person_id = fu.employee_id
347: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
348: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 359: l_approver_name per_all_people_f.full_name%type; -- Added for bug# 3732090

355: email_address VARCHAR2(2000);
356: notification_preference VARCHAR2(2000);
357: language VARCHAR2(2000);
358: territory VARCHAR2(2000);
359: l_approver_name per_all_people_f.full_name%type; -- Added for bug# 3732090
360: BEGIN
361: /* get stored values */
362: l_project_id := wf_engine.getItemAttrNumber(
363: itemtype => p_item_type

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

537: --This cursor returns internal users.
538: CURSOR getApprovedRejectedPerson IS
539: select distinct fu.user_id, fu.user_name, papf.email_address,
540: papf.full_name person_name
541: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
542: pa_project_role_types pprt
543: where object_type = 'PA_PROJECTS'
544: --and object_id = l_project_id Bug 4562762
545: -- Bug 4562762 : Added logic to select program too

Line 572: from fnd_user fu, per_all_people_f papf

568: and f2.function_id = f1.function_id)
569: UNION /*Added this clause for Approver 4291185 */
570: select distinct fu.user_id, fu.user_name, papf.email_address,
571: papf.full_name person_name
572: from fnd_user fu, per_all_people_f papf
573: where fu.user_id = fnd_global.USER_ID
574: and papf.person_id = fu.employee_id
575: and trunc(sysdate) between papf.effective_start_date
576: and nvl(papf.effective_end_date, sysdate+1)

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

584: /*
585: CURSOR getApprovedRejectedParty IS
586: select distinct fu.user_id, fu.user_name, papf.email_address,
587: papf.full_name person_name
588: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
589: pa_project_role_types pprt
590: where object_type = 'PA_PROJECTS'
591: and object_id = l_project_id
592: and ppp.resource_type_id = 112

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

607:
608: CURSOR getApprovedRejectedParty IS
609: select distinct fu.user_id, fu.user_name, papf.email_address,
610: papf.full_name person_name
611: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
612: pa_project_role_types pprt
613: where object_type = 'PA_PROJECTS'
614: and object_id = l_project_id
615: and ppp.resource_type_id = 112

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

636: --Bug No 3695601 Performance Fix Using EXISTS instead of IN
637: /* CURSOR getWorkplanViewerPerson IS
638: select distinct fu.user_id, fu.user_name, papf.email_address,
639: papf.full_name person_name
640: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
641: pa_project_role_types pprt
642: where object_type = 'PA_PROJECTS'
643: and object_id = l_project_id
644: and ppp.resource_type_id = 101

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

658: and f2.function_id = f1.function_id)
659: UNION
660: select distinct fu.user_id, fu.user_name, papf.email_address,
661: papf.full_name person_name
662: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
663: where ele.project_id = l_project_id
664: and ele.MANAGER_PERSON_ID = fu.employee_id
665: and papf.person_id = fu.employee_id
666: and trunc(sysdate) between papf.effective_start_date

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

670:
671: CURSOR getWorkplanViewerPerson IS
672: select distinct fu.user_id, fu.user_name, papf.email_address,
673: papf.full_name person_name
674: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
675: pa_project_role_types pprt
676: where object_type = 'PA_PROJECTS'
677: and object_id = l_project_id
678: and ppp.resource_type_id = 101

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

692: and f2.function_id = f1.function_id)
693: UNION
694: select distinct fu.user_id, fu.user_name, papf.email_address,
695: papf.full_name person_name
696: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
697: where ele.project_id = l_project_id
698: and ele.MANAGER_PERSON_ID = fu.employee_id
699: and papf.person_id = fu.employee_id
700: and trunc(sysdate) between papf.effective_start_date

Line 707: from fnd_user fu, per_all_people_f papf

703: and nvl(fu.end_date, sysdate+1)
704: UNION
705: select distinct fu.user_id, fu.user_name, papf.email_address,
706: papf.full_name person_name
707: from fnd_user fu, per_all_people_f papf
708: where fu.user_id = fnd_global.USER_ID
709: and papf.person_id = fu.employee_id
710: and trunc(sysdate) between papf.effective_start_date
711: and nvl(papf.effective_end_date, sysdate+1)

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

720: /*
721: CURSOR getWorkplanViewerParty IS
722: select distinct fu.user_id, fu.user_name, papf.email_address,
723: papf.full_name person_name
724: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
725: pa_project_role_types pprt
726: where object_type = 'PA_PROJECTS'
727: and object_id = l_project_id
728: and ppp.resource_type_id = 112

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

744:
745: CURSOR getWorkplanViewerParty IS
746: select distinct fu.user_id, fu.user_name, papf.email_address,
747: papf.full_name person_name
748: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
749: pa_project_role_types pprt
750: where object_type = 'PA_PROJECTS'
751: and object_id = l_project_id
752: and ppp.resource_type_id = 112