APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_SRP_INTEL_PERIODS

Line 67: cn_srp_intel_periods intel

63: greatest(cscg.start_date_active, intel.start_date) start_date,
64: decode(cscg.end_date_active, null, intel.end_date,
65: Least(cscg.end_date_active, intel.end_date)) end_date
66: FROM cn_srp_comp_groups_v cscg,
67: cn_srp_intel_periods intel
68: WHERE cscg.comp_group_id = p_group_id
69: and intel.salesrep_id = cscg.salesrep_id
70: and cscg.start_date_active <= intel.end_date
71: and (cscg.end_date_active is null or cscg.end_date_active >= intel.start_date);

Line 78: FROM cn_srp_intel_periods p

74: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
75: SELECT p.period_id,
76: greatest(p_start_date, p.start_date) start_date,
77: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
78: FROM cn_srp_intel_periods p
79: WHERE p.salesrep_id = p_salesrep_id
80: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
81: AND (p.end_date >= p_start_date);
82:

Line 312: cn_srp_intel_periods intel

308: greatest(cscg.start_date_active, intel.start_date) start_date,
309: decode(cscg.end_date_active, null, intel.end_date,
310: Least(cscg.end_date_active, intel.end_date)) end_date
311: FROM cn_srp_comp_groups_v cscg,
312: cn_srp_intel_periods intel
313: WHERE cscg.comp_group_id = p_group_id
314: and intel.salesrep_id = cscg.salesrep_id
315: and cscg.start_date_active <= intel.end_date
316: and (cscg.end_date_active is null or cscg.end_date_active >= intel.start_date);

Line 323: FROM cn_srp_intel_periods p

319: CURSOR periods(p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
320: SELECT p.period_id,
321: greatest(p_start_date, p.start_date) start_date,
322: Decode(p_end_date, NULL, p.end_date, Least(p_end_date, p.end_date)) end_date
323: FROM cn_srp_intel_periods p
324: WHERE p.salesrep_id = p_salesrep_id
325: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
326: AND (p.end_date >= p_start_date);
327: