APPS.XTR_REVAL_PROCESS_P dependencies on XTR_HEDGE_ATTRIBUTES

Line 6051: from XTR_HEDGE_ATTRIBUTES a,

6047: /* batch range. */
6048: /******************************************************/
6049: cursor C_REVAL_DATE(p_last_end_date DATE) is
6050: select a.start_date reval_date
6051: from XTR_HEDGE_ATTRIBUTES a,
6052: XTR_HEDGE_RELATIONSHIPS r
6053: where a.hedge_attribute_id = r.hedge_attribute_id
6054: and r.primary_code = rec.deal_no
6055: and r.instrument_item_flag = 'U'

Line 6060: from XTR_HEDGE_ATTRIBUTES a,

6056: and a.start_date < rec.revldate
6057: and a.start_date >= p_last_end_date
6058: union
6059: select nvl(discontinue_date, end_date) reval_date
6060: from XTR_HEDGE_ATTRIBUTES a,
6061: XTR_HEDGE_RELATIONSHIPS r
6062: where a.hedge_attribute_id = r.hedge_attribute_id
6063: and r.primary_code = rec.deal_no
6064: and r.instrument_item_flag = 'U'

Line 6184: from XTR_HEDGE_ATTRIBUTES

6180: and reclass_date < rec.revldate
6181: and last_reval_batch_id is NULL
6182: union
6183: select nvl(discontinue_date, end_date) reval_date
6184: from XTR_HEDGE_ATTRIBUTES
6185: where hedge_attribute_id = rec.deal_no
6186: and nvl(discontinue_date, end_date) < rec.revldate
6187: union
6188: select effective_date reval_date

Line 6211: from XTR_HEDGE_ATTRIBUTES

6207:
6208:
6209: cursor C_PROS_FREQ is
6210: select pros_frequency_num, pros_frequency_unit
6211: from XTR_HEDGE_ATTRIBUTES
6212: where hedge_attribute_id = rec.deal_no
6213: and PROS_METHOD <> 'NOTEST';
6214:
6215: /* This Cursor is added to populate hedge date when */

Line 6219: from XTR_HEDGE_ATTRIBUTES

6215: /* This Cursor is added to populate hedge date when */
6216: /* the prospective test is not done initially Bug 4201031 */
6217: cursor C_PROS_NOT_FOUND is
6218: select start_date
6219: from XTR_HEDGE_ATTRIBUTES
6220: where hedge_attribute_id = rec.deal_no
6221: and PROS_METHOD <> 'NOTEST';
6222:
6223: -- bug 4214554

Line 6228: from XTR_HEDGE_ATTRIBUTES hat , XTR_RECLASS_DETAILS rd

6224: /* This cursor is added to check that the date on which the
6225: prospective test is required should not exceed the hedge end date */
6226: cursor C_PROS_NOT_REQUIRED is
6227: select least( nvl(discontinue_date, end_date),reclass_date)
6228: from XTR_HEDGE_ATTRIBUTES hat , XTR_RECLASS_DETAILS rd
6229: where hat.hedge_attribute_id = rec.deal_no
6230: and PROS_METHOD <> 'NOTEST'
6231: and reclass_balance_amt = 0
6232: and hat.hedge_attribute_id = rd.hedge_attribute_id;

Line 9879: from XTR_HEDGE_ATTRIBUTES

9875: for update of FIRST_REVAL_BATCH_ID NOWAIT;
9876:
9877: Cursor CHK_LOCK_HEDGE is
9878: select rowid
9879: from XTR_HEDGE_ATTRIBUTES
9880: where hedge_attribute_id = rec.deal_no
9881: and first_batch_id is NULL
9882: for update of first_batch_id NOWAIT;
9883:

Line 9886: from XTR_HEDGE_ATTRIBUTES

9882: for update of first_batch_id NOWAIT;
9883:
9884: Cursor CHK_LAST_HEDGE is
9885: select rowid
9886: from XTR_HEDGE_ATTRIBUTES
9887: where hedge_attribute_id = rec.deal_no
9888: and last_batch_id is NULL
9889: for update of last_batch_id NOWAIT;
9890:

Line 9991: Update XTR_HEDGE_ATTRIBUTES

9987: if rec.deal_type = 'HEDGE' then
9988: Open CHK_LOCK_HEDGE;
9989: Fetch CHK_LOCK_HEDGE into l_deal_rowid;
9990: if CHK_LOCK_HEDGE%FOUND then
9991: Update XTR_HEDGE_ATTRIBUTES
9992: Set FIRST_BATCH_ID = rec.batch_id,
9993: INIT_FAIR_VALUE_RATE = rec.deal_ex_rate_one
9994: Where rowid = l_deal_rowid;
9995: close CHK_LOCK_HEDGE;

Line 10004: Update XTR_HEDGE_ATTRIBUTES

10000: if rec.effective_date <= rec.revldate then
10001: Open CHK_LAST_HEDGE;
10002: Fetch CHK_LAST_HEDGE into l_deaL_rowid;
10003: if CHK_LAST_HEDGE%FOUND then
10004: Update XTR_HEDGE_ATTRIBUTES
10005: Set LAST_BATCH_ID = rec.batch_id
10006: Where rowid = l_deal_rowid;
10007: close CHK_LAST_HEDGE;
10008: else

Line 10342: from XTR_HEDGE_ATTRIBUTES

10338: and first_reval_batch_id <> rec.batch_id;
10339:
10340: cursor C_FIRST_HEDGE is
10341: select 'Y'
10342: from XTR_HEDGE_ATTRIBUTES
10343: where hedge_attribute_id = rec.deal_no
10344: and first_batch_id is NOT NULL;
10345:
10346: l_dummy VARCHAR2(1);