APPS.JA_JAINPLA_XMLP_PKG dependencies on V$DATABASE

Line 578: V$DATABASE;

574: CURSOR GET_DBNAME IS
575: SELECT
576: NAME
577: FROM
578: V$DATABASE;
579: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
580: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
581: V_SID V$SESSION.SID%TYPE;
582: V_SERIAL V$SESSION.SERIAL#%TYPE;

Line 584: V_NAME V$DATABASE.NAME%TYPE;

580: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
581: V_SID V$SESSION.SID%TYPE;
582: V_SERIAL V$SESSION.SERIAL#%TYPE;
583: V_SPID V$PROCESS.SPID%TYPE;
584: V_NAME V$DATABASE.NAME%TYPE;
585:
586: BEGIN
587: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
588: LP_TRN_FROM_DATE := to_char(P_TRN_FROM_DATE,'DD-MON-YYYY');