APPS.JAI_RCV_RND_PKG dependencies on V$DATABASE

Line 109: v_name1 v$database.name%type;

105: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
106: v_sid v$session.sid%type;
107: v_serial v$session.serial#%type;
108: v_spid v$process.spid%type;
109: v_name1 v$database.name%type;
110:
111: CURSOR c_enable_trace(cp_conc_pname fnd_concurrent_programs.concurrent_program_name%type) IS
112: SELECT enable_trace
113: FROM fnd_concurrent_programs

Line 122: CURSOR get_dbname IS SELECT name FROM v$database;

118: FROM v$session a, v$process b
119: WHERE audsid = userenv('SESSIONID')
120: AND a.paddr = b.addr;
121:
122: CURSOR get_dbname IS SELECT name FROM v$database;
123:
124: CURSOR c_vendor(p_shipment_header_id IN NUMBER) IS
125: SELECT vendor_id, vendor_site_id, receipt_num
126: FROM rcv_shipment_headers