APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_DEALS

Line 763: from XTR_DEALS_V

759: cursor DET is
760: select MATURITY_DATE,CPARTY_CODE,CLIENT_CODE,PRODUCT_TYPE,
761: PORTFOLIO_CODE,SETTLE_ACCOUNT_NO,CPARTY_REF,
762: COMPANY_CODE,DEALER_CODE,DEAL_DATE,LIMIT_CODE
763: from XTR_DEALS_V
764: where DEAL_NO = l_deal_no
765: and deal_type = 'RTMM';
766: --
767: begin

Line 921: from XTR_DEALS_V

917: where CURRENCY = l_ccy;
918: --
919: cursor GET_YEAR_CALC_TYPE is
920: select YEAR_CALC_TYPE
921: from XTR_DEALS_V
922: where DEAL_NO = l_deal_no;
923: --
924: cursor DT_HOME_RATE is
925: select nvl(a.HCE_RATE,1) HCE_RATE

Line 964: from XTR_DEALS_V a,

960: pmt DT_ROW%ROWTYPE;
961: --
962: cursor COMP is
963: select b.INTEREST_ACTION
964: from XTR_DEALS_V a,
965: XTR_PAYMENT_SCHEDULE_V b
966: where a.DEAL_NO = l_deal_no
967: and b.PAYMENT_SCHEDULE_CODE = a.PAYMENT_SCHEDULE_CODE;
968: --

Line 972: from xtr_deals

968: --
969:
970: cursor cur_deal is
971: select day_count_type, rounding_type
972: from xtr_deals
973: where deal_no = l_deal_no;
974:
975: l_day_count_type xtr_deals.day_count_type%type;
976: l_rounding_type xtr_deals.rounding_type%type;

Line 975: l_day_count_type xtr_deals.day_count_type%type;

971: select day_count_type, rounding_type
972: from xtr_deals
973: where deal_no = l_deal_no;
974:
975: l_day_count_type xtr_deals.day_count_type%type;
976: l_rounding_type xtr_deals.rounding_type%type;
977: l_first_trans_flag varchar2(1);
978: l_fwd_Adjust number;
979:

Line 976: l_rounding_type xtr_deals.rounding_type%type;

972: from xtr_deals
973: where deal_no = l_deal_no;
974:
975: l_day_count_type xtr_deals.day_count_type%type;
976: l_rounding_type xtr_deals.rounding_type%type;
977: l_first_trans_flag varchar2(1);
978: l_fwd_Adjust number;
979:
980: l_exp_bal_adj_amt number; -- added for bug 3465496.