DBA Data[Home] [Help]

APPS.EDW_SEC_PKG dependencies on DBA_TABLES

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

649: x_step varchar2(50);
650: sql_stmt varchar2(1000);
651: BEGIN
652: -- Check if source
653: select count(*) into sorc_records from dba_tables
654: where owner = EDW_OWB_COLLECTION_UTIL.get_db_user('BIS')
655: and table_name = 'EDW_LOCAL_INSTANCE';
656:
657: IF sorc_records > 0 THEN