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.XTR_COMMON_FUNCTIONS dependencies on XTR_BATCH_EVENTS

Line 348: FROM xtr_batches b,xtr_batch_events e,xtr_revaluation_details r

344: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
345:
346: CURSOR chk_reval_tmm_irs(l_date date) IS
347: SELECT max(period_end)
348: FROM xtr_batches b,xtr_batch_events e,xtr_revaluation_details r
349: WHERE r.deal_no = p_deal_number
350: AND r.batch_id = b.batch_id
351: AND b.batch_id = e.batch_id
352: AND e.event_code = 'REVAL'

Line 357: FROM xtr_batches b,xtr_batch_events e,xtr_revaluation_details r

353: AND period_to > nvl(l_date, period_to -1);
354:
355: CURSOR chk_reval_others IS
356: SELECT ('Y')
357: FROM xtr_batches b,xtr_batch_events e,xtr_revaluation_details r
358: WHERE r.deal_no = nvl(p_deal_number, r.deal_no)
359: AND r.batch_id = b.batch_id
360: AND b.batch_id = e.batch_id
361: AND e.event_code = 'REVAL'