DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_RT_QUOTA_ASGNS_ALL

Line 447: FROM cn_rt_quota_asgns_all

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 ));