[Home] [Help]
443: AND nvl(split_flag, 'N') <> 'N';
444: BEGIN
445: SELECT rate_schedule_id, rt_quota_asgn_id
446: INTO l_rate_schedule_id, l_rt_quota_asgn_id
447: FROM cn_rt_quota_asgns_all
448: WHERE quota_id = p_quota_id
449: AND (calc_formula_id = p_calc_formula_id OR (calc_formula_id IS NULL AND p_calc_formula_id IS NULL))
450: AND (( end_date IS NOT NULL AND p_processed_date BETWEEN start_date AND end_date)
451: OR (end_date IS NULL AND p_processed_date >= start_date ));