417: WHERE rate_dimension_id = p_rate_dimension_id
418: ORDER BY tier_sequence;
419:
420: CURSOR tier_exp(p_calc_sql_exp_id NUMBER) IS
421: SELECT dbms_lob.substr(sql_select) sql_select,
422: dbms_lob.substr(sql_from) sql_from
423: FROM cn_calc_sql_exps_all
424: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
425:
418: ORDER BY tier_sequence;
419:
420: CURSOR tier_exp(p_calc_sql_exp_id NUMBER) IS
421: SELECT dbms_lob.substr(sql_select) sql_select,
422: dbms_lob.substr(sql_from) sql_from
423: FROM cn_calc_sql_exps_all
424: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
425:
426: CURSOR comm_amounts IS