APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 344: from XTR_ROLLOVER_TRANSACTIONS_V

340: order by DEAL_NUMBER,TRANSACTION_NUMBER;
341: --
342: CURSOR S_DATE is
343: select START_DATE,CURRENCY,DEAL_SUBTYPE
344: from XTR_ROLLOVER_TRANSACTIONS_V
345: where DEAL_NUMBER = l_deal_no
346: and TRANSACTION_NUMBER = l_trans_no;
347: -- Created cursor Bug 4226409
348: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is

Line 385: UPDATE XTR_ROLLOVER_TRANSACTIONS_V

381: OPEN SETTLE_DATE(l_rec_ref);
382: FETCH SETTLE_DATE INTO l_settle_date;
383: CLOSE SETTLE_DATE;
384: -- Modified Bug 4226409
385: UPDATE XTR_ROLLOVER_TRANSACTIONS_V
386: SET PI_AMOUNT_RECEIVED = l_amount,
387: MATURITY_DATE = l_date,
388: SETTLE_DATE = l_settle_date
389: WHERE DEAL_NUMBER = l_deal_no

Line 654: from XTR_ROLLOVER_TRANSACTIONS_V

650: where a.CURRENCY = l_ccy;
651: --
652: cursor START_ROW is
653: select max(START_DATE)
654: from XTR_ROLLOVER_TRANSACTIONS_V
655: where DEAL_NUMBER = l_deal_no
656: and START_DATE <= l_ref_date
657: and STATUS_CODE = 'CURRENT';
658: --

Line 661: from XTR_ROLLOVER_TRANSACTIONS_V

657: and STATUS_CODE = 'CURRENT';
658: --
659: cursor LAST_ROW is
660: select rowid
661: from XTR_ROLLOVER_TRANSACTIONS_V
662: where DEAL_NUMBER = l_deal_no
663: and START_DATE >= l_start_date
664: and STATUS_CODE = 'CURRENT'
665: order by START_DATE desc,nvl(SETTLE_DATE,MATURITY_DATE) desc,TRANSACTION_NUMBER desc;

Line 676: from XTR_ROLLOVER_TRANSACTIONS_V

672: INTEREST_SETTLED,PRINCIPAL_ACTION,TRANSACTION_NUMBER,
673: SETTLE_DATE,ACCUM_INTEREST_BF,PI_AMOUNT_DUE,PI_AMOUNT_RECEIVED,
674: ACCUM_INTEREST,ROWID,ADJUSTED_BALANCE,COMMENTS,
675: EXPECTED_BALANCE_BF,EXPECTED_BALANCE_OUT,PRINCIPAL_AMOUNT_TYPE,ENDORSER_CODE
676: from XTR_ROLLOVER_TRANSACTIONS_V
677: where DEAL_NUMBER = l_deal_no
678: and START_DATE >= l_start_date
679: and STATUS_CODE = 'CURRENT'
680: order by START_DATE asc,nvl(SETTLE_DATE,MATURITY_DATE) asc,TRANSACTION_NUMBER asc

Line 993: update XTR_ROLLOVER_TRANSACTIONS_V

989: hce_accum_int := (pmt.ACCUM_INTEREST / l_hce_rate);
990: hce_accum_int := xtr_fps2_p.interest_round(hce_accum_int, rounding_fac, l_rounding_type);
991: hce_due := round(pmt.PI_AMOUNT_DUE / l_hce_rate,rounding_fac);
992: --
993: update XTR_ROLLOVER_TRANSACTIONS_V
994: set START_DATE = pmt.START_DATE,
995: BALANCE_OUT_BF = pmt.BALANCE_OUT_BF,
996: BALANCE_OUT_BF_HCE = hce_balbf,
997: ACCUM_INTEREST_BF = pmt.ACCUM_INTEREST_BF,

Line 1110: delete from XTR_ROLLOVER_TRANSACTIONS_V

1106: end if;
1107: fetch DT_ROW INTO pmt;
1108: END LOOP;
1109: if l_nill_date is NOT NULL then
1110: delete from XTR_ROLLOVER_TRANSACTIONS_V
1111: where DEAL_NUMBER = l_deal_no
1112: and START_DATE >= l_nill_date;
1113: If SQL%Found then
1114: null;