APPS.CN_CALC_FORMULAS_PVT dependencies on CN_RATE_SCHEDULES

Line 184: from cn_rt_formula_asgns a, cn_rate_schedules s,

180: p_output_exp_id IN CN_CALC_FORMULAS.OUTPUT_EXP_ID%TYPE,
181: p_f_output_exp_id IN CN_CALC_FORMULAS.F_OUTPUT_EXP_ID%TYPE) IS
182: cursor rt_asgns is
183: select s.number_dim, d.dim_unit_code
184: from cn_rt_formula_asgns a, cn_rate_schedules s,
185: cn_rate_sch_dims r, cn_rate_dimensions d
186: where a.rate_schedule_id = s.rate_schedule_id
187: and s.rate_schedule_id = r.rate_schedule_id
188: and r.rate_dimension_id = d.rate_dimension_id

Line 1708: FROM cn_rate_schedules

1704: WHERE calc_sql_exp_id = l_f_output_exp_id;
1705:
1706: CURSOR check_dimensions IS
1707: SELECT 1
1708: FROM cn_rate_schedules
1709: WHERE number_dim <> l_number_dim
1710: AND rate_schedule_id IN (SELECT rate_schedule_id
1711: FROM cn_rt_formula_asgns
1712: WHERE calc_formula_id = p_calc_formula_id);