APPS.CN_SALES_HIER_PUB dependencies on CN_COMP_GROUPS

Line 67: cn_comp_groups cg

63:
64: SELECT distinct cg.name comp_group_name, cscg.comp_group_id comp_group_id
65: FROM
66: cn_srp_comp_groups_v cscg,
67: cn_comp_groups cg
68: WHERE
69: ((l_salesrep_id = -9999 ) OR (cscg.salesrep_id = l_salesrep_id)) AND
70: cscg.comp_group_id = l_comp_group_id AND
71: cscg.start_date_active <= l_date and

Line 142: cn_comp_groups cg

138: SELECT
139: hier.comp_group_id group_id, cg.name group_name
140: FROM
141: cn_comp_group_hier hier,
142: cn_comp_groups cg
143: WHERE
144: hier.parent_comp_group_id = l_comp_group_id and
145: hier.comp_group_id = cg.comp_group_id and
146: delete_flag <> 'Y' and