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 PER_ASSIGNMENTS_F

Line 99: per_assignments_f pa,

95:
96: select gp.person_id
97: into l_award_manager_id
98: from gms_personnel gp,
99: per_assignments_f pa,
100: per_assignment_status_types past
101: where gp.award_id = p_award_id
102: and gp.award_role = C_AWARD_MANAGER_ROLE
103: AND gp.start_date_active = ( select max(gp2.start_date_active)

Line 162: per_assignments_f pa,

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
166: AND ppp.start_date_active = ( select max(pp2.start_date_active)