DBA Data[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on CN_RATE_DIMENSIONS_ALL

Line 1640: FROM cn_rate_dimensions_all

1636:
1637: -- cursor to get the dim_unit_code
1638: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
1639: SELECT dim_unit_code
1640: FROM cn_rate_dimensions_all
1641: WHERE rate_dimension_id = (SELECT rate_dimension_id
1642: FROM cn_rate_sch_dims_all
1643: WHERE rate_dim_sequence = p_rate_dim_sequence
1644: AND rate_schedule_id = (SELECT rate_schedule_id

Line 3846: FROM cn_rate_dimensions_all

3842:
3843: -- cursor to get the dim_unit_code
3844: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
3845: SELECT dim_unit_code
3846: FROM cn_rate_dimensions_all
3847: WHERE rate_dimension_id = (SELECT rate_dimension_id
3848: FROM cn_rate_sch_dims_all
3849: WHERE rate_dim_sequence = p_rate_dim_sequence
3850: AND rate_schedule_id = (SELECT rate_schedule_id

Line 4314: FROM cn_rate_dimensions_all

4310: AND org_id = g_org_id;
4311:
4312: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS
4313: SELECT dim_unit_code
4314: FROM cn_rate_dimensions_all
4315: WHERE rate_dimension_id = (SELECT rate_dimension_id
4316: FROM cn_rate_sch_dims_all
4317: WHERE rate_dim_sequence = p_rate_dim_sequence
4318: AND rate_schedule_id = (SELECT rate_schedule_id