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 524: pa_project_role_types pprt

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

Line 571: pa_project_role_types pprt

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

Line 594: pa_project_role_types pprt

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

Line 623: pa_project_role_types pprt

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

Line 657: pa_project_role_types pprt

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

Line 707: pa_project_role_types pprt

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

Line 731: pa_project_role_types pprt

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