APPS.QRM_CALCULATORS_P dependencies on XTR_RM_MD_CURVES

Line 1286: FROM xtr_rm_md_curves

1282:
1283: -- for YIELD and IRVOL curves
1284: CURSOR get_default_curve(p_type VARCHAR2,p_base_ccy VARCHAR2) IS
1285: SELECT curve_code
1286: FROM xtr_rm_md_curves
1287: WHERE type=p_type and authorized_yn='Y' and ccy=p_base_ccy
1288: ORDER BY creation_date;
1289:
1290: -- for FXVOL curves

Line 1294: FROM xtr_rm_md_curves

1290: -- for FXVOL curves
1291: CURSOR get_default_curve_fx(p_type VARCHAR2,p_base_ccy VARCHAR2,
1292: p_contra_ccy VARCHAR2) IS
1293: SELECT curve_code
1294: FROM xtr_rm_md_curves
1295: WHERE type=p_type and authorized_yn='Y' and
1296: (ccy=p_base_ccy and contra_ccy=p_contra_ccy) or
1297: (ccy=p_contra_ccy and contra_ccy=p_base_ccy)
1298: ORDER BY creation_date;

Line 1910: select data_side into v_quote_basis from xtr_rm_md_curves where

1906: v_curve_type.extend;
1907: v_curve_type(2):='YIELD';
1908: IF v_quote_basis = 'DEFAULT' THEN
1909: --for curve default quote basis, get the actual value
1910: select data_side into v_quote_basis from xtr_rm_md_curves where
1911: curve_code = p_rate_curve;
1912: END IF;
1913: --get spot to settlement rates
1914: IF v_ss_bid is null or v_ss_ask is null or p_indicator = 'NC' THEN

Line 1949: select data_side into v_quote_basis from xtr_rm_md_curves where

1945: ELSIF p_indicator = 'CC' or p_indicator = 'CR' THEN
1946: -- get rates from curve
1947: IF v_quote_basis = 'DEFAULT' THEN
1948: --for curve default quote basis, get the actual value
1949: select data_side into v_quote_basis from xtr_rm_md_curves where
1950: curve_code = p_rate_curve;
1951: END IF;
1952: v_base_currency.extend;
1953: v_base_currency(2):=v_base_currency(1);