DBA Data[Home] [Help]

APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_BASE_TABLES_V

Line 204: -- cn_base_tables_v, if not, means other Hierarchy Type already use

200: EXCEPTION
201: WHEN no_data_found THEN
202: BEGIN
203: -- for new Hierarchy Type, it's base_table should exist in
204: -- cn_base_tables_v, if not, means other Hierarchy Type already use
205: -- this table
206: SELECT 1 INTO l_dummy FROM cn_base_tables_v
207: WHERE table_id = x_base_table_id
208: AND name = p_hier_record.base_table_name and org_id=p_org_id

Line 206: SELECT 1 INTO l_dummy FROM cn_base_tables_v

202: BEGIN
203: -- for new Hierarchy Type, it's base_table should exist in
204: -- cn_base_tables_v, if not, means other Hierarchy Type already use
205: -- this table
206: SELECT 1 INTO l_dummy FROM cn_base_tables_v
207: WHERE table_id = x_base_table_id
208: AND name = p_hier_record.base_table_name and org_id=p_org_id
209: ;
210: EXCEPTION