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 PA_PROJECT_ROLE_TYPES

Line 542: pa_project_role_types pprt

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
546: and object_id IN (select ver.project_id

Line 589: pa_project_role_types pprt

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
593: and ppp.project_role_id = pprt.project_role_id

Line 612: pa_project_role_types pprt

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
616: and ppp.project_role_id = pprt.project_role_id

Line 641: pa_project_role_types pprt

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
645: and ppp.project_role_id = pprt.project_role_id

Line 675: pa_project_role_types pprt

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
679: and ppp.project_role_id = pprt.project_role_id

Line 725: pa_project_role_types pprt

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
729: and ppp.project_role_id = pprt.project_role_id

Line 749: pa_project_role_types pprt

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
753: and ppp.project_role_id = pprt.project_role_id