APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_RT_FORMULA_ASGNS

Line 3672: FROM cn_rt_formula_asgns

3668: l_null_date CONSTANT DATE := TO_DATE ('31-12-3000', 'DD-MM-YYYY');
3669: l_tmp NUMBER;
3670: /* CURSOR rt_formula_curs IS
3671: SELECT Count(1)
3672: FROM cn_rt_formula_asgns
3673: WHERE calc_formula_id = p_calc_formula_id
3674: and ( start_Date < p_start_date
3675: or ( p_end_date IS NOT NULL
3676: and end_date IS NULL )

Line 3698: FROM cn_rt_formula_asgns

3694: SELECT MIN (start_date),
3695: MAX (NVL (end_date, l_null_date))
3696: INTO l_temp_start_date,
3697: l_temp_end_date
3698: FROM cn_rt_formula_asgns
3699: WHERE calc_formula_id = p_calc_formula_id;
3700:
3701: IF l_temp_start_date IS NOT NULL AND ((p_start_date < l_temp_start_date) OR (NVL (p_end_date, l_null_date) > l_temp_end_date))
3702: THEN