DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on V$PROCESS

Line 6077: from v$session s, v$process p

6073: -- get the session details and application_id to insert into gl_bc_packets (Bug Fix 6769905)
6074: -- session id and serial id is fetched from v$session, same as that in psa_funds_checker_pkg.get_session_details
6075: select s.audsid, s.serial#
6076: into l_session_id, l_serial_id
6077: from v$session s, v$process p
6078: where s.paddr = p.addr
6079: and s.audsid = USERENV('SESSIONID');
6080:
6081: l_application_id := fnd_global.resp_appl_id;