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.AP_WEB_AME_PKG dependencies on PA_PROJECT_PLAYERS

Line 161: from pa_project_players ppp,

157: -----------------------------------------------------
158:
159: select ppp.person_id
160: into l_project_manager_id
161: from pa_project_players ppp,
162: per_assignments_f pa,
163: per_assignment_status_types past
164: where ppp.project_id = p_project_id
165: and ppp.project_role_type = C_PROJECT_MANAGER_ROLE_TYPE

Line 167: from pa_project_players pp2

163: per_assignment_status_types past
164: where ppp.project_id = p_project_id
165: and ppp.project_role_type = C_PROJECT_MANAGER_ROLE_TYPE
166: AND ppp.start_date_active = ( select max(pp2.start_date_active)
167: from pa_project_players pp2
168: where pp2.project_role_type = C_PROJECT_MANAGER_ROLE_TYPE
169: and pp2.project_id = p_project_id
170: and pp2.start_date_active <= trunc(sysdate)
171: )