APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_RATE_DIM_TIERS

Line 657: FROM cn_rate_dim_tiers

653: WHERE calc_sql_exp_id = p_calc_sql_exp_id
654: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
655: )
656: OR (EXISTS(SELECT 1
657: FROM cn_rate_dim_tiers
658: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
659:
660: CURSOR exp_exists IS
661: SELECT 1

Line 965: FROM cn_rate_dim_tiers

961: WHERE calc_sql_exp_id = p_calc_sql_exp_id
962: OR f_calc_sql_exp_id = p_calc_sql_exp_id)
963: )
964: OR (EXISTS(SELECT 1
965: FROM cn_rate_dim_tiers
966: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
967: BEGIN
968: -- Standard Start of API savepoint
969: SAVEPOINT delete_expression;

Line 1092: FROM cn_rate_dim_tiers

1088: UNION ALL
1089: SELECT name
1090: FROM cn_rate_dimensions
1091: WHERE rate_dimension_id in (SELECT rate_dimension_id
1092: FROM cn_rate_dim_tiers
1093: WHERE min_exp_id = p_calc_sql_exp_id
1094: OR max_exp_id = p_calc_sql_exp_id)
1095: UNION ALL
1096: SELECT name