134: AND da.deal_calc_id=dc.deal_calc_id
135: AND dc.deal_no=v.deal_no
136: AND dc.transaction_no=v.transaction_no;
137: CURSOR get_deal_currency_col IS
138: SELECT deal_currency_col FROM qrm_ana_atts_lookups
139: WHERE attribute_name=v_meas_temp;
140:
141: BEGIN
142: IF (g_proc_level>=g_debug_level) THEN
181: v_amount_type := TRUE;
182: v_meas_temp := p_measure;
183: END IF;
184: IF v_amount_type THEN
185: --get the deal_currency_col from qrm_ana_atts_lookups
186: OPEN get_deal_currency_col;
187: FETCH get_deal_currency_col INTO v_deal_currency_col;
188: CLOSE get_deal_currency_col;
189: IF v_deal_currency_col='BASE_CCY' THEN
475: v_col_name VARCHAR2(200);
476:
477: CURSOR get_nom_denom IS
478: SELECT numerator,denominator,num_denom_origin
479: FROM qrm_ana_atts_lookups
480: WHERE attribute_name=v_col_name;
481: CURSOR get_origin IS
482: SELECT origin FROM qrm_ana_atts_lookups
483: WHERE attribute_name=v_col_name;
478: SELECT numerator,denominator,num_denom_origin
479: FROM qrm_ana_atts_lookups
480: WHERE attribute_name=v_col_name;
481: CURSOR get_origin IS
482: SELECT origin FROM qrm_ana_atts_lookups
483: WHERE attribute_name=v_col_name;
484: v_deal_type_arr SYSTEM.QRM_VARCHAR_table;
485: v_market_type_arr SYSTEM.QRM_VARCHAR_table;
486: v_count NUMBER;
1498: SELECT DECODE(a.type,'R',1,'C',2,'M',3,4) seq, a.att_order,
1499: a.attribute_name, a.type, a.total_average, a.percentage, l.numerator,
1500: l.denominator, l.origin, l.amount, l.ccy_aggregate, l.sensitivity,
1501: l.num_denom_origin
1502: FROM qrm_analysis_atts a, qrm_ana_atts_lookups l
1503: WHERE a.attribute_name=l.attribute_name AND a.analysis_name=p_name
1504: AND history_flag='S'
1505: ORDER BY 1,2;
1506:
3879: v_agg_col_curr SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
3880:
3881: CURSOR get_lookup_prop IS
3882: SELECT origin,attribute_type,numerator,denominator,num_denom_origin
3883: FROM qrm_ana_atts_lookups
3884: WHERE attribute_name=v_temp;
3885:
3886: BEGIN
3887: IF (g_proc_level>=g_debug_level) THEN