APPS.XTR_REVAL_PROCESS_P dependencies on XTR_RECLASS_DETAILS

Line 1331: from XTR_RECLASS_DETAILS

1327: and instrument_item_flag = 'I';
1328:
1329: Cursor C_HEDGE_BAL is
1330: select min(reclass_balance_amt)
1331: from XTR_RECLASS_DETAILS
1332: where hedge_attribute_id = rec.deal_no
1333: and reclass_date <= rec.batch_start;
1334:
1335: --Bug 9336651 starts

Line 6069: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R

6065: and nvl(a.discontinue_date, a.end_date) < rec.revldate
6066: and nvl(a.discontinue_date, a.end_date) >= p_last_end_date
6067: union
6068: select c.reclass_date reval_date
6069: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R
6070: where c.hedge_attribute_id = r.hedge_attribute_id
6071: and r.primary_code = rec.deal_no
6072: and r.instrument_item_flag = 'U'
6073: and c.reclass_date > p_last_end_date -- bug 4214523

Line 6178: from XTR_RECLASS_DETAILS

6174: PROCEDURE xtr_revl_fv_hedge (rec IN OUT NOCOPY xtr_revl_rec) IS
6175:
6176: Cursor C_REVAL_DATE is -- Find hedge reclass date within the batch range
6177: select reclass_date reval_date
6178: from XTR_RECLASS_DETAILS
6179: where hedge_attribute_id = rec.deal_no
6180: and reclass_date < rec.revldate
6181: and last_reval_batch_id is NULL
6182: union

Line 6202: from xtr_reclass_details

6198: -- Bug 4234575 This cursor has been added so that totally reclassified
6199: -- hedges are not picked up for revaluation
6200: cursor C_BALANCE_AMT(p_revldate DATE) is
6201: select RECLASS_BALANCE_AMT
6202: from xtr_reclass_details
6203: where HEDGE_ATTRIBUTE_ID = rec.deal_no
6204: and RECLASS_DATE = (select max(RECLASS_DATE) from xtr_reclass_details
6205: where HEDGE_ATTRIBUTE_ID = rec.deal_no and rECLASS_DATE < p_revldate);
6206:

Line 6204: and RECLASS_DATE = (select max(RECLASS_DATE) from xtr_reclass_details

6200: cursor C_BALANCE_AMT(p_revldate DATE) is
6201: select RECLASS_BALANCE_AMT
6202: from xtr_reclass_details
6203: where HEDGE_ATTRIBUTE_ID = rec.deal_no
6204: and RECLASS_DATE = (select max(RECLASS_DATE) from xtr_reclass_details
6205: where HEDGE_ATTRIBUTE_ID = rec.deal_no and rECLASS_DATE < p_revldate);
6206:
6207:
6208:

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 6367: from XTR_RECLASS_DETAILS

6363: p_complete_flag IN VARCHAR2) IS
6364:
6365: cursor C_CUR_HEDGE_AMT is
6366: select reclass_details_id, reclass_balance_amt
6367: from XTR_RECLASS_DETAILS
6368: where hedge_attribute_id = rec.deal_no
6369: and reclass_date >= p_start_date
6370: and reclass_date < p_end_date;
6371:

Line 6404: Update XTR_RECLASS_DETAILS

6400: Fetch C_CUR_HEDGE_AMT into l_reclass_id, l_cur_hedge_amt;
6401: if C_CUR_HEDGE_AMT%FOUND then
6402: rec.face_value := l_cur_hedge_amt;
6403:
6404: Update XTR_RECLASS_DETAILS
6405: Set last_reval_batch_id = rec.batch_id
6406: where reclass_details_id = l_reclass_id;
6407: end if;
6408: Close C_CUR_HEDGE_AMT;

Line 6516: from XTR_RECLASS_DETAILS

6512: p_complete_flag IN VARCHAR2) IS
6513:
6514: cursor C_CUR_HEDGE_AMT is
6515: select reclass_details_id, reclass_balance_amt
6516: from XTR_RECLASS_DETAILS
6517: where hedge_attribute_id = rec.deal_no
6518: and reclass_date >= p_start_date
6519: and reclass_date < p_end_date; -- bug 4276970
6520:

Line 6582: Update XTR_RECLASS_DETAILS

6578: rec.face_value := l_cur_hedge_amt;
6579:
6580: LOG_MSG(' xtr_hedge_fwd_rate rec.face_value',rec.face_value);
6581:
6582: Update XTR_RECLASS_DETAILS
6583: Set last_reval_batch_id = rec.batch_id
6584: where reclass_details_id = l_reclass_id;
6585: end if;
6586: Close C_CUR_HEDGE_AMT;