DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on V$DATABASE

Line 2921: SELECT name FROM v$database;

2917: WHERE audsid = userenv('SESSIONID')
2918: AND a.paddr = b.addr;
2919:
2920: CURSOR get_dbname IS
2921: SELECT name FROM v$database;
2922:
2923: v_enable_trace fnd_concurrent_programs.enable_trace%TYPE;
2924: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2925: sid V$SESSION.SID%TYPE;

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

2924: audsid NUMBER; --File.Sql.35 Cbabu := userenv('SESSIONID');
2925: sid V$SESSION.SID%TYPE;
2926: serial V$SESSION.SERIAL#%TYPE;
2927: spid V$PROCESS.SPID%TYPE;
2928: v_name1 V$DATABASE.NAME%TYPE;
2929:
2930:
2931: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.batch_quot_taxes_copy';
2932: BEGIN