APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on V$INSTANCE

Line 43: FROM v$instance

39: INTO db_version_major,
40: db_version_minor
41: FROM
42: (SELECT SUBSTR(REPLACE(REPLACE(version, '.', '|'), ',', '|'), 1, instr(REPLACE(REPLACE(version, '.', '|'), ',', '|'), '|', 1, 2) -1) version_text
43: FROM v$instance
44: );
45:
46: END parse_db_version;
47: -- -----------------------------------------------

Line 479: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1)) from v$instance;

475: l_remote_create_synonym varchar2(1000);
476:
477: --cursor c_get_db_version is
478: -- hbandi replaced the previous query to new query for the #BUG8221231
479: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1)) from v$instance;
480: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1),'99.9','NLS_NUMERIC_CHARACTERS = ''.,''') from v$instance;
481:
482:
483:

Line 480: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1),'99.9','NLS_NUMERIC_CHARACTERS = ''.,''') from v$instance;

476:
477: --cursor c_get_db_version is
478: -- hbandi replaced the previous query to new query for the #BUG8221231
479: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1)) from v$instance;
480: -- select to_number(substr(version, 1, instr(version,'.',1,2)-1),'99.9','NLS_NUMERIC_CHARACTERS = ''.,''') from v$instance;
481:
482:
483:
484: -- l_db_version number;