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: l_in_btw_date_adj_flag VARCHAR2(1); -- Bug 7375762
965:

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: l_in_btw_date_adj_flag VARCHAR2(1); -- Bug 7375762
965:
966: cursor THIS_DEAL is

Line 976: from XTR_DEALS

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

Line 1035: from XTR_DEALS_V a,

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