APPS.XTR_REVAL_PROCESS_P dependencies on XTR_HEDGE_ATTRIBUTES

Line 6034: from XTR_HEDGE_ATTRIBUTES a,

6030: /* batch range. */
6031: /******************************************************/
6032: cursor C_REVAL_DATE(p_last_end_date DATE) is
6033: select a.start_date reval_date
6034: from XTR_HEDGE_ATTRIBUTES a,
6035: XTR_HEDGE_RELATIONSHIPS r
6036: where a.hedge_attribute_id = r.hedge_attribute_id
6037: and r.primary_code = rec.deal_no
6038: and r.instrument_item_flag = 'U'

Line 6043: from XTR_HEDGE_ATTRIBUTES a,

6039: and a.start_date < rec.revldate
6040: and a.start_date >= p_last_end_date
6041: union
6042: select nvl(discontinue_date, end_date) reval_date
6043: from XTR_HEDGE_ATTRIBUTES a,
6044: XTR_HEDGE_RELATIONSHIPS r
6045: where a.hedge_attribute_id = r.hedge_attribute_id
6046: and r.primary_code = rec.deal_no
6047: and r.instrument_item_flag = 'U'

Line 6167: from XTR_HEDGE_ATTRIBUTES

6163: and reclass_date < rec.revldate
6164: and last_reval_batch_id is NULL
6165: union
6166: select nvl(discontinue_date, end_date) reval_date
6167: from XTR_HEDGE_ATTRIBUTES
6168: where hedge_attribute_id = rec.deal_no
6169: and nvl(discontinue_date, end_date) < rec.revldate
6170: union
6171: select effective_date reval_date

Line 6194: from XTR_HEDGE_ATTRIBUTES

6190:
6191:
6192: cursor C_PROS_FREQ is
6193: select pros_frequency_num, pros_frequency_unit
6194: from XTR_HEDGE_ATTRIBUTES
6195: where hedge_attribute_id = rec.deal_no
6196: and PROS_METHOD <> 'NOTEST';
6197:
6198: /* This Cursor is added to populate hedge date when */

Line 6202: from XTR_HEDGE_ATTRIBUTES

6198: /* This Cursor is added to populate hedge date when */
6199: /* the prospective test is not done initially Bug 4201031 */
6200: cursor C_PROS_NOT_FOUND is
6201: select start_date
6202: from XTR_HEDGE_ATTRIBUTES
6203: where hedge_attribute_id = rec.deal_no
6204: and PROS_METHOD <> 'NOTEST';
6205:
6206: -- bug 4214554

Line 6211: from XTR_HEDGE_ATTRIBUTES hat , XTR_RECLASS_DETAILS rd

6207: /* This cursor is added to check that the date on which the
6208: prospective test is required should not exceed the hedge end date */
6209: cursor C_PROS_NOT_REQUIRED is
6210: select least( nvl(discontinue_date, end_date),reclass_date)
6211: from XTR_HEDGE_ATTRIBUTES hat , XTR_RECLASS_DETAILS rd
6212: where hat.hedge_attribute_id = rec.deal_no
6213: and PROS_METHOD <> 'NOTEST'
6214: and reclass_balance_amt = 0
6215: and hat.hedge_attribute_id = rd.hedge_attribute_id;

Line 9860: from XTR_HEDGE_ATTRIBUTES

9856: for update of FIRST_REVAL_BATCH_ID NOWAIT;
9857:
9858: Cursor CHK_LOCK_HEDGE is
9859: select rowid
9860: from XTR_HEDGE_ATTRIBUTES
9861: where hedge_attribute_id = rec.deal_no
9862: and first_batch_id is NULL
9863: for update of first_batch_id NOWAIT;
9864:

Line 9867: from XTR_HEDGE_ATTRIBUTES

9863: for update of first_batch_id NOWAIT;
9864:
9865: Cursor CHK_LAST_HEDGE is
9866: select rowid
9867: from XTR_HEDGE_ATTRIBUTES
9868: where hedge_attribute_id = rec.deal_no
9869: and last_batch_id is NULL
9870: for update of last_batch_id NOWAIT;
9871:

Line 9972: Update XTR_HEDGE_ATTRIBUTES

9968: if rec.deal_type = 'HEDGE' then
9969: Open CHK_LOCK_HEDGE;
9970: Fetch CHK_LOCK_HEDGE into l_deal_rowid;
9971: if CHK_LOCK_HEDGE%FOUND then
9972: Update XTR_HEDGE_ATTRIBUTES
9973: Set FIRST_BATCH_ID = rec.batch_id,
9974: INIT_FAIR_VALUE_RATE = rec.deal_ex_rate_one
9975: Where rowid = l_deal_rowid;
9976: close CHK_LOCK_HEDGE;

Line 9985: Update XTR_HEDGE_ATTRIBUTES

9981: if rec.effective_date <= rec.revldate then
9982: Open CHK_LAST_HEDGE;
9983: Fetch CHK_LAST_HEDGE into l_deaL_rowid;
9984: if CHK_LAST_HEDGE%FOUND then
9985: Update XTR_HEDGE_ATTRIBUTES
9986: Set LAST_BATCH_ID = rec.batch_id
9987: Where rowid = l_deal_rowid;
9988: close CHK_LAST_HEDGE;
9989: else

Line 10323: from XTR_HEDGE_ATTRIBUTES

10319: and first_reval_batch_id <> rec.batch_id;
10320:
10321: cursor C_FIRST_HEDGE is
10322: select 'Y'
10323: from XTR_HEDGE_ATTRIBUTES
10324: where hedge_attribute_id = rec.deal_no
10325: and first_batch_id is NOT NULL;
10326:
10327: l_dummy VARCHAR2(1);