DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_T dependencies on V$INSTANCE

Line 1773: select version into db_versn from v$instance;

1769: l_tmp_name := NULL;
1770:
1771: --check database version. it should be 9i or above
1772: --get the version
1773: select version into db_versn from v$instance;
1774: edw_log.put_line( 'Database Version:= '||db_versn);
1775: select replace(substr(version,1,instr(version,'.',1,2)-1),'.') into db_versn from v$instance;
1776:
1777: l_stmt:= 'select tablespace_name from all_tables where table_name='''||g_dimension_name||''' and owner='''||get_bis_schema_name||'''';

Line 1775: select replace(substr(version,1,instr(version,'.',1,2)-1),'.') into db_versn from v$instance;

1771: --check database version. it should be 9i or above
1772: --get the version
1773: select version into db_versn from v$instance;
1774: edw_log.put_line( 'Database Version:= '||db_versn);
1775: select replace(substr(version,1,instr(version,'.',1,2)-1),'.') into db_versn from v$instance;
1776:
1777: l_stmt:= 'select tablespace_name from all_tables where table_name='''||g_dimension_name||''' and owner='''||get_bis_schema_name||'''';
1778: execute immediate l_stmt into l_tspace_name;
1779: