DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_RT_QUOTA_ASGNS_ALL

Line 448: FROM cn_rt_quota_asgns_all

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