1645: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
1646: SELECT dim_unit_code
1647: FROM cn_rate_dimensions_all
1648: WHERE rate_dimension_id = (SELECT rate_dimension_id
1649: FROM cn_rate_sch_dims_all
1650: WHERE rate_dim_sequence = p_rate_dim_sequence
1651: AND rate_schedule_id = (SELECT rate_schedule_id
1652: FROM cn_rt_formula_asgns_all
1653: WHERE calc_formula_id = g_formula_id
3857: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
3858: SELECT dim_unit_code
3859: FROM cn_rate_dimensions_all
3860: WHERE rate_dimension_id = (SELECT rate_dimension_id
3861: FROM cn_rate_sch_dims_all
3862: WHERE rate_dim_sequence = p_rate_dim_sequence
3863: AND rate_schedule_id = (SELECT rate_schedule_id
3864: FROM cn_rt_formula_asgns_all
3865: WHERE calc_formula_id = g_formula_id
4325: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
4326: SELECT dim_unit_code
4327: FROM cn_rate_dimensions_all
4328: WHERE rate_dimension_id = (SELECT rate_dimension_id
4329: FROM cn_rate_sch_dims_all
4330: WHERE rate_dim_sequence = p_rate_dim_sequence
4331: AND rate_schedule_id = (SELECT rate_schedule_id
4332: FROM cn_rt_formula_asgns_all
4333: WHERE calc_formula_id = g_formula_id