79: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
80: SELECT p.period_id,
81: greatest(p_start_date, p.start_date) start_date,
82: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
83: FROM cn_srp_intel_periods p
84: WHERE p.salesrep_id = p_salesrep_id
85: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
86: AND (p.end_date >= p_start_date);
87:
374: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
375: SELECT p.period_id,
376: greatest(p_start_date, p.start_date) start_date,
377: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
378: FROM cn_srp_intel_periods p
379: WHERE p.salesrep_id = p_salesrep_id
380: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
381: AND (p.end_date >= p_start_date);
382:
598: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
599: SELECT p.period_id,
600: greatest(p_start_date, p.start_date) start_date,
601: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
602: FROM cn_srp_intel_periods p
603: WHERE p.salesrep_id = p_salesrep_id
604: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
605: AND (p.end_date >= p_start_date);
606:
806: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
807: SELECT p.period_id,
808: greatest(p_start_date, p.start_date) start_date,
809: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
810: FROM cn_srp_intel_periods p
811: WHERE p.salesrep_id = p_salesrep_id
812: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
813: AND (p.end_date >= p_start_date);
814: