APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_COMP_GROUP_HIER

Line 48: FROM cn_comp_group_hier hier,

44: l_parent_cg_id IN NUMBER,
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)

Line 64: FROM cn_comp_group_hier hier,

60: l_parent_cg_id IN NUMBER,
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'

Line 176: FROM cn_comp_group_hier cgh

172: INTO l_top_hier_tbl(l_counter).cg_salesrep_id,
173: l_top_hier_tbl(l_counter).parent_comp_group_id,
174: l_top_hier_tbl(l_counter).start_date_active,
175: l_top_hier_tbl(l_counter).end_date_active
176: FROM cn_comp_group_hier cgh
177: WHERE comp_group_id = l_comp_group_id
178: AND cgh.start_date_active <= p_date
179: AND ((cgh.end_date_active is null) OR
180: (cgh.end_date_active >= p_date));