APPS.CN_ROLLUP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

	SELECT
	  role_id,
	  greatest(start_date_active, p_srp.start_date) start_date,
	  least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date,
	  manager_flag
	  FROM cn_srp_comp_groups_v
	  WHERE comp_group_id = p_srp.group_id
	  AND salesrep_id = p_srp.salesrep_id
      AND org_id = p_org_id
	  AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)
	    AND (p_srp.end_date IS NULL OR p_srp.end_date >= start_date_active);

Line: 156

	SELECT
	  salesrep_id,
	  role_id,
	  manager_flag,
	  greatest(start_date_active, p_group.start_date) start_date,
	  least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
	  FROM cn_srp_comp_groups_v
	  WHERE comp_group_id = p_group.group_id
      AND org_id = p_org_id
	  AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
	    AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);

Line: 394

	SELECT
	  comp_group_id,
	  role_id,
	  manager_flag,
	  greatest(start_date_active, p_srp.start_date) start_date,
	  least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date
	FROM cn_srp_comp_groups_v
	WHERE salesrep_id = p_srp.salesrep_id
      AND org_id = p_org_id
	  AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)
	  AND (p_srp.end_date IS NULL OR p_srp.end_date >= start_date_active);

Line: 513

	SELECT
	  parent_group_id,
	  denorm_level,
	  greatest(start_date_active, p_group.start_date) start_date,
	  least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
	FROM cn_groups_denorm_v
	WHERE group_id = p_group.group_id
	  AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
	  AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);

Line: 626

	SELECT
	  group_id,
	  denorm_level,
	  greatest(start_date_active, p_group.start_date) start_date,
	  least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
	FROM cn_groups_denorm_v
	WHERE parent_group_id = p_group.group_id
	  AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
	  AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);

Line: 743

	SELECT
	  salesrep_id,
	  greatest(start_date_active, p_srp.start_date) start_date,
	  least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date
	FROM cn_srp_comp_groups_v
	WHERE comp_group_id = p_srp.group_id
	AND salesrep_id <> p_srp.salesrep_id
	AND manager_flag = 'Y'
    AND org_id = p_org_id
	AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)
	AND (p_srp.end_date IS NULL OR p_srp.end_date >= start_date_active);

Line: 756

	SELECT
	  salesrep_id,
	  greatest(start_date_active, p_start_date) start_date,
	  least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
	FROM cn_srp_comp_groups_v
       WHERE comp_group_id = p_group_id
         AND org_id = p_org_id
         AND (end_date_active IS NULL OR p_start_date <= end_date_active)
         AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line: 912

	SELECT
	  salesrep_id,
	  greatest(start_date_active, p_start_date) start_date,
	  least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
	FROM cn_srp_comp_groups_v
	WHERE comp_group_id = p_group_id
      AND org_id = p_org_id
	  AND (end_date_active IS NULL OR p_start_date <= end_date_active)
	  AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line: 923

	SELECT manager_flag
	  FROM cn_srp_comp_groups_v
	  WHERE comp_group_id = p_srp.group_id
      AND org_id = p_org_id
	  AND salesrep_id = p_srp.salesrep_id
	  AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
	  AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);

Line: 1079

      SELECT DISTINCT comp_group_id
	FROM cn_srp_comp_groups_v
	WHERE salesrep_id = p_srp.salesrep_id
    AND org_id = p_org_id
	AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
	AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);

Line: 1087

      SELECT DISTINCT salesrep_id
	FROM cn_srp_comp_groups_v
	WHERE comp_group_id = p_group_id
	AND salesrep_id <> p_srp.salesrep_id
    AND org_id = p_org_id
	AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
	AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);

Line: 1096

      SELECT DISTINCT salesrep_id
	FROM cn_srp_comp_groups_v srp,
	cn_groups_denorm_v hier
	WHERE srp.comp_group_id = hier.group_id
    AND srp.org_id = p_org_id
	AND hier.parent_group_id = p_group_id
	AND (p_srp.end_date IS NULL OR hier.start_date_active <= p_srp.end_date)
	AND (hier.end_date_active IS NULL OR hier.end_date_active >= p_srp.start_date)
	AND (p_srp.end_date IS NULL OR srp.start_date_active <= p_srp.end_date)
	AND (srp.end_date_active IS NULL OR srp.end_date_active >= p_srp.start_date);

Line: 1129

      SELECT COUNT(*)
	INTO l_temp
	FROM cn_srp_comp_groups_v
	WHERE salesrep_id = p_srp.salesrep_id
    AND org_id = p_org_id
	AND comp_group_id = eachgroup.comp_group_id
	AND manager_flag = 'Y'
	AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
	AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);