DBA Data[Home] [Help]

APPS.BSC_SYNC_MVLOGS dependencies on BSC_DB_TABLES

Line 50: , bsc_db_tables tbls

46: procedure alter_objective_input_tables(p_level in varchar2, p_owner in varchar2) is
47: cursor cInputTables(p_level_col varchar2, p_datatype varchar2, p_data_length varchar2 ) is
48: select cols.table_name
49: from all_tab_columns cols
50: , bsc_db_tables tbls
51: where cols.owner=p_owner
52: and cols.table_name=tbls.table_name
53: and tbls.table_type=0
54: and cols.column_name =p_level_col