DBA Data[Home] [Help]

APPS.BIS_INIT dependencies on DBA_TABLES

Line 46: select count(*) into sorc_records from dba_tables

42: -- Identify if instance is source or/and warehouse
43:
44: -- Check if source
45:
46: select count(*) into sorc_records from dba_tables
47: where owner = l_schema --bug 3871867
48: and table_name = 'EDW_LOCAL_INSTANCE';
49:
50: IF sorc_records > 0 THEN

Line 58: select count(*) into wh_records from dba_tables

54:
55:
56: -- Check if warehouse
57:
58: select count(*) into wh_records from dba_tables
59: where owner = l_schema --bug 3871867
60: and table_name = 'EDW_SOURCE_INSTANCES';
61:
62: IF wh_records > 0 THEN