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 dependencies on PA_PROJECT_ROLE_TYPES

Line 477: pa_project_role_types pprt

473: CURSOR getProjMemberEditPerson IS
474: select distinct fu.user_id, fu.user_name, papf.email_address,
475: papf.full_name person_name
476: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
477: pa_project_role_types pprt
478: where object_type = 'PA_PROJECTS'
479: and object_id = l_project_id
480: and ppp.resource_type_id = 101
481: and ppp.project_role_id = pprt.project_role_id

Line 513: pa_project_role_types pprt

509: CURSOR getProjMemberEditParty IS
510: select distinct fu.user_id, fu.user_name, papf.email_address,
511: papf.full_name person_name
512: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
513: pa_project_role_types pprt
514: where object_type = 'PA_PROJECTS'
515: and object_id = l_project_id
516: and ppp.resource_type_id = 112
517: and ppp.project_role_id = pprt.project_role_id

Line 536: pa_project_role_types pprt

532: CURSOR getProjMemberEditParty IS
533: select distinct fu.user_id, fu.user_name, papf.email_address,
534: papf.full_name person_name
535: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
536: pa_project_role_types pprt
537: where object_type = 'PA_PROJECTS'
538: and object_id = l_project_id
539: and ppp.resource_type_id = 112
540: and ppp.project_role_id = pprt.project_role_id