APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJECT_PARTIES

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