APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_RECLASS_DETAILS

Line 85: from xtr_reclass_details

81: and instrument_item_flag = 'I';
82:
83: cursor reclass is
84: select reclass_hedge_amt
85: from xtr_reclass_details
86: where reclass_details_id = p_reclass_id;
87:
88: cursor prv_reclass is
89: select sum(reclass_hedge_amt), sum(reclass_gain_loss_amt)

Line 90: from xtr_reclass_details

86: where reclass_details_id = p_reclass_id;
87:
88: cursor prv_reclass is
89: select sum(reclass_hedge_amt), sum(reclass_gain_loss_amt)
90: from xtr_reclass_details
91: where hedge_attribute_id = p_hedge_no
92: and reclass_date < p_date;
93:
94: cursor cum_eff is

Line 209: LOG_MSG('event', 'updating xtr_reclass_details...');

205: l_rec_gl_amt := round((l_rec_hdg_amt/l_rem_hedge_amt) * ( nvl(l_cum_eff_amt,0) - nvl(l_cum_rec_gl_amt,0)), l_round);
206:
207: LOG_MSG('l_rec_gl_amt' ,l_rec_gl_amt);
208:
209: LOG_MSG('event', 'updating xtr_reclass_details...');
210:
211: update xtr_reclass_details
212: set reclass_gain_loss_amt = nvl(l_rec_gl_amt,0),
213: retro_batch_id = p_batch_id

Line 211: update xtr_reclass_details

207: LOG_MSG('l_rec_gl_amt' ,l_rec_gl_amt);
208:
209: LOG_MSG('event', 'updating xtr_reclass_details...');
210:
211: update xtr_reclass_details
212: set reclass_gain_loss_amt = nvl(l_rec_gl_amt,0),
213: retro_batch_id = p_batch_id
214: where reclass_details_id = p_reclass_id;
215:

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