APPS.CN_FORMULA_GEN_PKG dependencies on CN_RATE_DIMENSIONS_ALL

Line 1647: FROM cn_rate_dimensions_all

1643:
1644: -- cursor to get the dim_unit_code
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

Line 3859: FROM cn_rate_dimensions_all

3855:
3856: -- cursor to get the dim_unit_code
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

Line 4327: FROM cn_rate_dimensions_all

4323: AND org_id = g_org_id;
4324:
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