APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_SRP_COMP_GROUPS_V

Line 86: FROM cn_srp_comp_groups_v cscg,

82: cscg.start_date_active mgr_start_date,
83: cscg.end_date_active mgr_end_date,
84: cscg.role_id mgr_role_id,
85: cscg.srp_role_id mgr_srp_role_id
86: FROM cn_srp_comp_groups_v cscg,
87: cn_salesreps cs
88: WHERE cscg.comp_group_id = l_comp_group_id
89: AND cscg.salesrep_id = cs.salesrep_id
90: AND cscg.start_date_active <= l_date

Line 119: FROM cn_comp_groups cg, cn_srp_comp_groups_v cscg

115: -- Changed by Zack at May-06-2002 to add checking for p_date is within the
116: -- effective date range of srp comp group assignment
117: SELECT count(*)
118: INTO l_counter
119: FROM cn_comp_groups cg, cn_srp_comp_groups_v cscg
120: WHERE cg.comp_group_id = p_comp_group_id
121: AND cg.start_date_active <= p_date
122: AND ((cg.end_date_active is null) OR
123: (cg.end_date_active >= p_date))