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
1654: AND org_id = g_org_id
1655: AND ROWNUM = 1));
1656:
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
3866: AND org_id = g_org_id
3867: AND ROWNUM = 1));
3868:
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
4334: AND org_id = g_org_id
4335: AND ROWNUM = 1));
4336: