103: -- we only insert if there are overlap
104: -- clku, fix the date not overlap issue
105: IF ((l_start_date IS NOT NULL) AND (TRUNC (l_start_date) <= TRUNC (NVL (l_end_date, l_start_date))))
106: THEN
107: SELECT cn_rt_quota_asgns_s.NEXTVAL,
108: p_calc_formula_id,
109: p_quota_id,
110: l_start_date,
111: l_end_date,