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_HEDGE_PROCESS_P dependencies on XTR_HEDGE_STRATEGIES

Line 73: from xtr_hedge_strategies s, xtr_hedge_attributes h

69: l_hd_excl_prv_cum NUMBER;
70:
71: cursor hdg is
72: select s.hedge_approach, h.hedge_amount, h.exclusion_item_code
73: from xtr_hedge_strategies s, xtr_hedge_attributes h
74: where s.strategy_code = h.strategy_code
75: and h.hedge_attribute_id = p_hedge_no;
76:
77: cursor ref_amt is

Line 386: from xtr_hedge_attributes ha, xtr_hedge_strategies hs

382: nvl(sum(reclass_gain_loss_amt),0) reclass_gain_loss_amt
383: from xtr_deal_retro_tests d
384: where d.batch_id = p_batch_id
385: and d.hedge_attribute_id in (select hedge_attribute_id
386: from xtr_hedge_attributes ha, xtr_hedge_strategies hs
387: where ha.strategy_code = hs.strategy_code
388: and hs.hedge_type = 'CASHFLOW')
389: group by deal_number, amount_type, result_date
390: order by deal_number, amount_type, result_date;

Line 978: from xtr_reclass_details r, xtr_hedge_attributes h, xtr_hedge_strategies s

974: ,NULL unrealised_pl
975: ,NULL realised_pl
976: ,NULL curr_gain_loss_amount
977: ,NULL realized_flag
978: from xtr_reclass_details r, xtr_hedge_attributes h, xtr_hedge_strategies s
979: where r.hedge_attribute_id = h.hedge_attribute_id
980: and h.strategy_code = s.strategy_code
981: and h.company_code = p_company
982: and r.reclass_date <= p_cb_end_date