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.HRI_OLTP_DISC_TRAINING dependencies on OTA_ACTIVITY_VERSIONS

Line 79: ota_activity_versions tav

75: ,evt.duration_units
76: ,evt.title
77: ,tav.version_name
78: FROM
79: ota_activity_versions tav
80: ,ota_events evt
81: ,ota_program_memberships pm
82: WHERE evt.activity_version_id = tav.activity_version_id
83: AND evt.event_id = pm.event_id

Line 88: l_activity_version_name ota_activity_versions.version_name%type;

84: AND pm.program_event_id = p_program_event_id;
85:
86: program_member_rec program_member_csr%rowtype;
87:
88: l_activity_version_name ota_activity_versions.version_name%type;
89: l_duration ota_events.duration%type := 0;
90: l_event_duration ota_events.duration%type := 0;
91: l_event_name ota_events.title%type;
92: l_pro_rata_amount number := 0;