DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on V$DATABASE

Line 2200: SELECT name FROM v$database;

2196: WHERE audsid = userenv('SESSIONID')
2197: AND a.paddr = b.addr;
2198:
2199: CURSOR get_dbname IS
2200: SELECT name FROM v$database;
2201:
2202: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2203: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2204: sid V$SESSION.SID%TYPE;

Line 2207: v_name1 V$DATABASE.NAME%TYPE;

2203: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2204: sid V$SESSION.SID%TYPE;
2205: serial V$SESSION.SERIAL#%TYPE;
2206: spid V$PROCESS.SPID%TYPE;
2207: v_name1 V$DATABASE.NAME%TYPE;
2208:
2209:
2210: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.batch_quot_taxes_copy';
2211: BEGIN