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: l_buf Varchar2(500);

Line 6052: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R

6048: and nvl(a.discontinue_date, a.end_date) < rec.revldate
6049: and nvl(a.discontinue_date, a.end_date) >= p_last_end_date
6050: union
6051: select c.reclass_date reval_date
6052: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R
6053: where c.hedge_attribute_id = r.hedge_attribute_id
6054: and r.primary_code = rec.deal_no
6055: and r.instrument_item_flag = 'U'
6056: and c.reclass_date > p_last_end_date -- bug 4214523

Line 6161: from XTR_RECLASS_DETAILS

6157: PROCEDURE xtr_revl_fv_hedge (rec IN OUT NOCOPY xtr_revl_rec) IS
6158:
6159: Cursor C_REVAL_DATE is -- Find hedge reclass date within the batch range
6160: select reclass_date reval_date
6161: from XTR_RECLASS_DETAILS
6162: where hedge_attribute_id = rec.deal_no
6163: and reclass_date < rec.revldate
6164: and last_reval_batch_id is NULL
6165: union

Line 6185: from xtr_reclass_details

6181: -- Bug 4234575 This cursor has been added so that totally reclassified
6182: -- hedges are not picked up for revaluation
6183: cursor C_BALANCE_AMT(p_revldate DATE) is
6184: select RECLASS_BALANCE_AMT
6185: from xtr_reclass_details
6186: where HEDGE_ATTRIBUTE_ID = rec.deal_no
6187: and RECLASS_DATE = (select max(RECLASS_DATE) from xtr_reclass_details
6188: where HEDGE_ATTRIBUTE_ID = rec.deal_no and rECLASS_DATE < p_revldate);
6189:

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

6183: cursor C_BALANCE_AMT(p_revldate DATE) is
6184: select RECLASS_BALANCE_AMT
6185: from xtr_reclass_details
6186: where HEDGE_ATTRIBUTE_ID = rec.deal_no
6187: and RECLASS_DATE = (select max(RECLASS_DATE) from xtr_reclass_details
6188: where HEDGE_ATTRIBUTE_ID = rec.deal_no and rECLASS_DATE < p_revldate);
6189:
6190:
6191:

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

6346: p_complete_flag IN VARCHAR2) IS
6347:
6348: cursor C_CUR_HEDGE_AMT is
6349: select reclass_details_id, reclass_balance_amt
6350: from XTR_RECLASS_DETAILS
6351: where hedge_attribute_id = rec.deal_no
6352: and reclass_date >= p_start_date
6353: and reclass_date < p_end_date;
6354:

Line 6387: Update XTR_RECLASS_DETAILS

6383: Fetch C_CUR_HEDGE_AMT into l_reclass_id, l_cur_hedge_amt;
6384: if C_CUR_HEDGE_AMT%FOUND then
6385: rec.face_value := l_cur_hedge_amt;
6386:
6387: Update XTR_RECLASS_DETAILS
6388: Set last_reval_batch_id = rec.batch_id
6389: where reclass_details_id = l_reclass_id;
6390: end if;
6391: Close C_CUR_HEDGE_AMT;

Line 6497: from XTR_RECLASS_DETAILS

6493: p_complete_flag IN VARCHAR2) IS
6494:
6495: cursor C_CUR_HEDGE_AMT is
6496: select reclass_details_id, reclass_balance_amt
6497: from XTR_RECLASS_DETAILS
6498: where hedge_attribute_id = rec.deal_no
6499: and reclass_date >= p_start_date
6500: and reclass_date < p_end_date; -- bug 4276970
6501:

Line 6563: Update XTR_RECLASS_DETAILS

6559: rec.face_value := l_cur_hedge_amt;
6560:
6561: LOG_MSG(' xtr_hedge_fwd_rate rec.face_value',rec.face_value);
6562:
6563: Update XTR_RECLASS_DETAILS
6564: Set last_reval_batch_id = rec.batch_id
6565: where reclass_details_id = l_reclass_id;
6566: end if;
6567: Close C_CUR_HEDGE_AMT;