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_PARTIES

Line 476: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

472: --get all project member who has edit privileges
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

Line 512: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

508: /*
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

Line 535: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

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