APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_DIMENSIONS_VL

Line 198: SELECT dimension_id INTO x_dimension_id FROM cn_dimensions_vl

194: cn_message_pkg.debug('-- Hier value ID = ' || x_hier_value_id);
195:
196: -- Create new hierarchy type if not exist
197: BEGIN
198: SELECT dimension_id INTO x_dimension_id FROM cn_dimensions_vl
199: WHERE name = p_hier_record.hierarchy_type and org_id=p_org_id;
200: EXCEPTION
201: WHEN no_data_found THEN
202: BEGIN