APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_DEALS_V

Line 486: from XTR_DEALS_V

482: cursor DET is
483: select MATURITY_DATE,CPARTY_CODE,CLIENT_CODE,PRODUCT_TYPE,
484: PORTFOLIO_CODE,SETTLE_ACCOUNT_NO,CPARTY_REF,
485: COMPANY_CODE,DEALER_CODE,DEAL_DATE,LIMIT_CODE
486: from XTR_DEALS_V
487: where DEAL_NO = l_deal_no
488: and deal_type = 'RTMM';
489: --
490: begin

Line 644: from XTR_DEALS_V

640: where CURRENCY = l_ccy;
641: --
642: cursor GET_YEAR_CALC_TYPE is
643: select YEAR_CALC_TYPE
644: from XTR_DEALS_V
645: where DEAL_NO = l_deal_no;
646: --
647: cursor DT_HOME_RATE is
648: select nvl(a.HCE_RATE,1) HCE_RATE

Line 687: from XTR_DEALS_V a,

683: pmt DT_ROW%ROWTYPE;
684: --
685: cursor COMP is
686: select b.INTEREST_ACTION
687: from XTR_DEALS_V a,
688: XTR_PAYMENT_SCHEDULE_V b
689: where a.DEAL_NO = l_deal_no
690: and b.PAYMENT_SCHEDULE_CODE = a.PAYMENT_SCHEDULE_CODE;
691: --