APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJECT_PARTIES

Line 302: fnd_user fu, pa_project_parties p

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
306: and NVL(p.END_DATE_ACTIVE, sysdate+1)

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