APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_DEALS_V

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