APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_RATE_DIM_TIERS

Line 650: FROM cn_rate_dim_tiers

646: WHERE calc_sql_exp_id = p_calc_sql_exp_id
647: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
648: )
649: OR (EXISTS(SELECT 1
650: FROM cn_rate_dim_tiers
651: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
652:
653: CURSOR exp_exists IS
654: SELECT 1

Line 957: FROM cn_rate_dim_tiers

953: WHERE calc_sql_exp_id = p_calc_sql_exp_id
954: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
955: )
956: OR (EXISTS(SELECT 1
957: FROM cn_rate_dim_tiers
958: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT delete_expression;

Line 1084: FROM cn_rate_dim_tiers

1080: UNION ALL
1081: SELECT name
1082: FROM cn_rate_dimensions
1083: WHERE rate_dimension_id in (SELECT rate_dimension_id
1084: FROM cn_rate_dim_tiers
1085: WHERE min_exp_id = p_calc_sql_exp_id
1086: OR max_exp_id = p_calc_sql_exp_id)
1087: UNION ALL
1088: SELECT name