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_REVAL_PROCESS_P dependencies on XTR_FX_ELIGIBLE_DEALS_V

Line 501: Select * from XTR_FX_ELIGIBLE_DEALS_V

497: Select * from XTR_ELIGIBLE_HEDGES_V
498: where eligible_date <= l_batch_end and company_code = l_company_code;
499:
500: Cursor c_fx_hedge_deal is
501: Select * from XTR_FX_ELIGIBLE_DEALS_V
502: where eligible_date <= l_batch_end and company_code = l_company_code
503: and deal_no in (select h.primary_code
504: from xtr_hedge_relationships H, xtr_revaluation_details R
505: where h.instrument_item_flag = 'U'

Line 510: Select * from XTR_FX_ELIGIBLE_DEALS_V

506: and r.batch_id = p_batch_id
507: and h.hedge_attribute_id = r.deal_no);
508:
509: Cursor c_fx_deal is
510: Select * from XTR_FX_ELIGIBLE_DEALS_V
511: where eligible_date <= l_batch_end and company_code = l_company_code
512: and deal_no not in (select h.primary_code
513: from xtr_hedge_relationships H, xtr_revaluation_details R
514: where h.instrument_item_flag = 'U'

Line 6060: from xtr_fx_eligible_deals_v

6056: and c.reclass_date > p_last_end_date -- bug 4214523
6057: and c.reclass_date < rec.revldate
6058: union
6059: select effective_date reval_date
6060: from xtr_fx_eligible_deals_v
6061: where deal_no = rec.deal_no
6062: and effective_date < rec.revldate
6063: union
6064: select period_end reval_date