APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_SALESREPS

Line 87: cn_salesreps cs

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
91: AND ((cscg.end_date_active is null) OR