APPS.QRM_CALCULATORS_P dependencies on XTR_PRO_PARAM

Line 115: FROM xtr_pro_param WHERE param_name = 'SYSTEM_FUNCTIONAL_CCY';

111:
112: --if currency is null defaults value to XTR Reporting Curr.
113: IF (p_ccy IS NULL) THEN
114: SELECT param_value INTO p_ccy
115: FROM xtr_pro_param WHERE param_name = 'SYSTEM_FUNCTIONAL_CCY';
116: END IF;
117:
118: IF (g_proc_level>=g_debug_level) THEN
119: xtr_risk_debug_pkg.dpop(null,'QRM_CALCULATORS_P.NI_CALCULATOR');

Line 1854: select param_value from xtr_pro_param

1850: v_sm_ask NUMBER :=p_sm_ask;
1851: v_fra_rec_in XTR_MM_COVERS.INT_FORW_RATE_IN_REC_TYPE;
1852: v_fra_rec_out XTR_MM_COVERS.INT_FORW_RATE_OUT_REC_TYPE;
1853: CURSOR default_currency_cursor is
1854: select param_value from xtr_pro_param
1855: where param_name = 'SYSTEM_FUNCTIONAL_CCY';
1856: v_curve_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE('YIELD');
1857: v_curve_code SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE(p_rate_curve,p_rate_curve);
1858: v_base_currency SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();

Line 2092: select param_value from xtr_pro_param

2088: v_settlement_rate NUMBER :=p_settlement_rate;
2089: v_fra_rec_in XTR_MM_COVERS.FRA_SETTLEMENT_IN_REC_TYPE;
2090: v_fra_rec_out XTR_MM_COVERS.FRA_SETTLEMENT_OUT_REC_TYPE;
2091: CURSOR default_currency_cursor is
2092: select param_value from xtr_pro_param
2093: where param_name = 'SYSTEM_FUNCTIONAL_CCY';
2094: v_curve_type SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE('YIELD');
2095: v_curve_code SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE(p_rate_curve);
2096: v_base_currency SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();