APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_DEALS

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: --

Line 695: from xtr_deals

691: --
692:
693: cursor cur_deal is
694: select day_count_type, rounding_type
695: from xtr_deals
696: where deal_no = l_deal_no;
697:
698: l_day_count_type xtr_deals.day_count_type%type;
699: l_rounding_type xtr_deals.rounding_type%type;

Line 698: l_day_count_type xtr_deals.day_count_type%type;

694: select day_count_type, rounding_type
695: from xtr_deals
696: where deal_no = l_deal_no;
697:
698: l_day_count_type xtr_deals.day_count_type%type;
699: l_rounding_type xtr_deals.rounding_type%type;
700: l_first_trans_flag varchar2(1);
701: l_fwd_Adjust number;
702:

Line 699: l_rounding_type xtr_deals.rounding_type%type;

695: from xtr_deals
696: where deal_no = l_deal_no;
697:
698: l_day_count_type xtr_deals.day_count_type%type;
699: l_rounding_type xtr_deals.rounding_type%type;
700: l_first_trans_flag varchar2(1);
701: l_fwd_Adjust number;
702:
703: l_exp_bal_adj_amt number; -- added for bug 3465496.