APPS.CN_ROLLUP_PVT dependencies on CN_SRP_COMP_GROUPS_V

Line 47: FROM cn_srp_comp_groups_v

43: role_id,
44: greatest(start_date_active, p_srp.start_date) start_date,
45: least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date,
46: manager_flag
47: FROM cn_srp_comp_groups_v
48: WHERE comp_group_id = p_srp.group_id
49: AND salesrep_id = p_srp.salesrep_id
50: AND org_id = p_org_id
51: AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)

Line 162: FROM cn_srp_comp_groups_v

158: role_id,
159: manager_flag,
160: greatest(start_date_active, p_group.start_date) start_date,
161: least(nvl(end_date_active, p_group.end_date), nvl(p_group.end_date, end_date_active)) end_date
162: FROM cn_srp_comp_groups_v
163: WHERE comp_group_id = p_group.group_id
164: AND org_id = p_org_id
165: AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
166: AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);

Line 400: FROM cn_srp_comp_groups_v

396: role_id,
397: manager_flag,
398: greatest(start_date_active, p_srp.start_date) start_date,
399: least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date
400: FROM cn_srp_comp_groups_v
401: WHERE salesrep_id = p_srp.salesrep_id
402: AND org_id = p_org_id
403: AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)
404: AND (p_srp.end_date IS NULL OR p_srp.end_date >= start_date_active);

Line 747: FROM cn_srp_comp_groups_v

743: SELECT
744: salesrep_id,
745: greatest(start_date_active, p_srp.start_date) start_date,
746: least(nvl(end_date_active, p_srp.end_date), nvl(p_srp.end_date, end_date_active)) end_date
747: FROM cn_srp_comp_groups_v
748: WHERE comp_group_id = p_srp.group_id
749: AND salesrep_id <> p_srp.salesrep_id
750: AND manager_flag = 'Y'
751: AND org_id = p_org_id

Line 797: FROM cn_srp_comp_groups_v

793: SELECT
794: salesrep_id,
795: greatest(start_date_active, p_start_date) start_date,
796: least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
797: FROM cn_srp_comp_groups_v
798: WHERE comp_group_id = p_group_id
799: AND org_id = p_org_id
800: AND (end_date_active IS NULL OR p_start_date <= end_date_active)
801: AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line 953: FROM cn_srp_comp_groups_v

949: SELECT
950: salesrep_id,
951: greatest(start_date_active, p_start_date) start_date,
952: least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
953: FROM cn_srp_comp_groups_v
954: WHERE comp_group_id = p_group_id
955: AND org_id = p_org_id
956: AND (end_date_active IS NULL OR p_start_date <= end_date_active)
957: AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line 961: FROM cn_srp_comp_groups_v

957: AND (p_end_date IS NULL OR p_end_date >= start_date_active);
958:
959: CURSOR mgr_check IS
960: SELECT manager_flag
961: FROM cn_srp_comp_groups_v
962: WHERE comp_group_id = p_srp.group_id
963: AND org_id = p_org_id
964: AND salesrep_id = p_srp.salesrep_id
965: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)

Line 1117: FROM cn_srp_comp_groups_v

1113: l_temp NUMBER(15);
1114:
1115: CURSOR groups_csr IS
1116: SELECT DISTINCT comp_group_id
1117: FROM cn_srp_comp_groups_v
1118: WHERE salesrep_id = p_srp.salesrep_id
1119: AND org_id = p_org_id
1120: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
1121: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);

Line 1125: FROM cn_srp_comp_groups_v

1121: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);
1122:
1123: CURSOR members_csr (p_group_id NUMBER) IS
1124: SELECT DISTINCT salesrep_id
1125: FROM cn_srp_comp_groups_v
1126: WHERE comp_group_id = p_group_id
1127: AND salesrep_id <> p_srp.salesrep_id
1128: AND org_id = p_org_id
1129: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)

Line 1134: FROM cn_srp_comp_groups_v srp,

1130: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);
1131:
1132: CURSOR descendant_csr(p_group_id NUMBER) IS
1133: SELECT DISTINCT salesrep_id
1134: FROM cn_srp_comp_groups_v srp,
1135: cn_groups_denorm_v hier
1136: WHERE srp.comp_group_id = hier.group_id
1137: AND srp.org_id = p_org_id
1138: AND hier.parent_group_id = p_group_id

Line 1168: FROM cn_srp_comp_groups_v

1164:
1165: FOR eachgroup IN groups_csr LOOP
1166: SELECT COUNT(*)
1167: INTO l_temp
1168: FROM cn_srp_comp_groups_v
1169: WHERE salesrep_id = p_srp.salesrep_id
1170: AND org_id = p_org_id
1171: AND comp_group_id = eachgroup.comp_group_id
1172: AND manager_flag = 'Y'