DBA Data[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on CN_RATE_SCH_DIMS_ALL

Line 1649: FROM cn_rate_sch_dims_all

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

Line 3861: FROM cn_rate_sch_dims_all

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

Line 4329: FROM cn_rate_sch_dims_all

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