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 GMS_PERSONNEL

Line 98: from gms_personnel gp,

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

Line 104: from gms_personnel gp2

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)
104: from gms_personnel gp2
105: where gp2.award_role = C_AWARD_MANAGER_ROLE
106: and gp2.award_id = p_award_id
107: and gp2.start_date_active <= trunc(sysdate)
108: )