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 760: FROM cn_srp_comp_groups_v

756: SELECT
757: salesrep_id,
758: greatest(start_date_active, p_start_date) start_date,
759: least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
760: FROM cn_srp_comp_groups_v
761: WHERE comp_group_id = p_group_id
762: AND org_id = p_org_id
763: AND (end_date_active IS NULL OR p_start_date <= end_date_active)
764: AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line 916: FROM cn_srp_comp_groups_v

912: SELECT
913: salesrep_id,
914: greatest(start_date_active, p_start_date) start_date,
915: least(nvl(end_date_active, p_end_date), nvl(p_end_date, end_date_active)) end_date
916: FROM cn_srp_comp_groups_v
917: WHERE comp_group_id = p_group_id
918: AND org_id = p_org_id
919: AND (end_date_active IS NULL OR p_start_date <= end_date_active)
920: AND (p_end_date IS NULL OR p_end_date >= start_date_active);

Line 924: FROM cn_srp_comp_groups_v

920: AND (p_end_date IS NULL OR p_end_date >= start_date_active);
921:
922: CURSOR mgr_check IS
923: SELECT manager_flag
924: FROM cn_srp_comp_groups_v
925: WHERE comp_group_id = p_srp.group_id
926: AND org_id = p_org_id
927: AND salesrep_id = p_srp.salesrep_id
928: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)

Line 1080: FROM cn_srp_comp_groups_v

1076: l_temp NUMBER(15);
1077:
1078: CURSOR groups_csr IS
1079: SELECT DISTINCT comp_group_id
1080: FROM cn_srp_comp_groups_v
1081: WHERE salesrep_id = p_srp.salesrep_id
1082: AND org_id = p_org_id
1083: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
1084: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);

Line 1088: FROM cn_srp_comp_groups_v

1084: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);
1085:
1086: CURSOR members_csr (p_group_id NUMBER) IS
1087: SELECT DISTINCT salesrep_id
1088: FROM cn_srp_comp_groups_v
1089: WHERE comp_group_id = p_group_id
1090: AND salesrep_id <> p_srp.salesrep_id
1091: AND org_id = p_org_id
1092: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)

Line 1097: FROM cn_srp_comp_groups_v srp,

1093: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);
1094:
1095: CURSOR descendant_csr(p_group_id NUMBER) IS
1096: SELECT DISTINCT salesrep_id
1097: FROM cn_srp_comp_groups_v srp,
1098: cn_groups_denorm_v hier
1099: WHERE srp.comp_group_id = hier.group_id
1100: AND srp.org_id = p_org_id
1101: AND hier.parent_group_id = p_group_id

Line 1131: FROM cn_srp_comp_groups_v

1127:
1128: FOR eachgroup IN groups_csr LOOP
1129: SELECT COUNT(*)
1130: INTO l_temp
1131: FROM cn_srp_comp_groups_v
1132: WHERE salesrep_id = p_srp.salesrep_id
1133: AND org_id = p_org_id
1134: AND comp_group_id = eachgroup.comp_group_id
1135: AND manager_flag = 'Y'