APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_COMP_GROUPS

Line 49: cn_comp_groups cg

45: l_date IN DATE) IS
46: SELECT hier.comp_group_id group_id, cg.name group_name,
47: hier.start_date_active,hier.end_date_active
48: FROM cn_comp_group_hier hier,
49: cn_comp_groups cg
50: WHERE hier.parent_comp_group_id = l_parent_cg_id
51: AND hier.comp_group_id = cg.comp_group_id
52: AND hier.comp_group_id <> DECODE(p_focus_cg_id,'0',p_comp_group_id,p_focus_cg_id)
53: AND delete_flag <> 'Y'

Line 65: cn_comp_groups cg

61: l_date IN DATE) IS
62: SELECT hier.comp_group_id group_id, cg.name group_name,
63: hier.start_date_active,hier.end_date_active
64: FROM cn_comp_group_hier hier,
65: cn_comp_groups cg
66: WHERE hier.parent_comp_group_id = l_parent_cg_id
67: AND hier.comp_group_id = cg.comp_group_id
68: AND delete_flag <> 'Y'
69: AND hier.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))

Line 196: FROM cn_comp_groups cg

192: INTO l_top_hier_tbl(l_counter).cg_salesrep_id,
193: l_top_hier_tbl(l_counter).parent_comp_group_id,
194: l_top_hier_tbl(l_counter).start_date_active,
195: l_top_hier_tbl(l_counter).end_date_active
196: FROM cn_comp_groups cg
197: WHERE comp_group_id = l_comp_group_id
198: AND cg.start_date_active <= p_date
199: AND ((cg.end_date_active is null) OR
200: (cg.end_date_active >= p_date));

Line 225: FROM cn_comp_groups

221: END IF;
222: BEGIN
223: SELECT name
224: INTO x_mgr_tbl(l_out_counter).cg_salesrep_name
225: FROM cn_comp_groups
226: WHERE comp_group_id = l_top_hier_tbl(l_counter).cg_salesrep_id;
227: EXCEPTION
228: WHEN OTHERS THEN
229: NULL;