APPS.XTR_CALC_P dependencies on XTR_DEALS

Line 961: l_dual_authorisation_by xtr_deals.dual_authorisation_by%type ;

957: l_mark VARCHAR2(1);
958: cnt NUMBER;
959:
960: -- 3958736
961: l_dual_authorisation_by xtr_deals.dual_authorisation_by%type ;
962: l_dual_authorisation_on xtr_deals.dual_authorisation_on%type ;
963:
964: cursor THIS_DEAL is
965: select DEAL_DATE, COMPANY_CODE, DEAL_SUBTYPE,

Line 962: l_dual_authorisation_on xtr_deals.dual_authorisation_on%type ;

958: cnt NUMBER;
959:
960: -- 3958736
961: l_dual_authorisation_by xtr_deals.dual_authorisation_by%type ;
962: l_dual_authorisation_on xtr_deals.dual_authorisation_on%type ;
963:
964: cursor THIS_DEAL is
965: select DEAL_DATE, COMPANY_CODE, DEAL_SUBTYPE,
966: PRODUCT_TYPE, PORTFOLIO_CODE, CURRENCY,

Line 974: from XTR_DEALS

970: FACE_VALUE_AMOUNT, cparty_ref,
971: start_date, --Add Interest Override
972: DUAL_AUTHORISATION_BY, -- bug 3958736
973: DUAL_AUTHORISATION_ON
974: from XTR_DEALS
975: where DEAL_NO = l_deal_no
976: and DEAL_TYPE = 'RTMM';
977:
978: cursor CHK_REF is

Line 1033: from XTR_DEALS_V a,

1029: pmt DT_ROW%ROWTYPE;
1030:
1031: cursor COMP is
1032: select b.INTEREST_ACTION
1033: from XTR_DEALS_V a,
1034: XTR_PAYMENT_SCHEDULE_V b
1035: where a.DEAL_NO = l_deal_no
1036: and b.PAYMENT_SCHEDULE_CODE = a.PAYMENT_SCHEDULE_CODE;
1037: