APPS.PSA_BC_XML_REPORT_PUB dependencies on V$SESSION

Line 3283: FROM v$session

3279:
3280: DELETE FROM psa_bc_xml_clob pbxc
3281: WHERE (((SYSDATE - pbxc.creation_date) > 1) OR
3282: (NOT EXISTS (SELECT 'x'
3283: FROM v$session
3284: WHERE audsid = pbxc.session_id
3285: AND Serial# = pbxc.serial_id)));
3286:
3287: psa_utils.debug_other_string(g_state_level,l_api_name,

Line 3293: FROM v$session s, v$process p

3289:
3290:
3291: SELECT s.audsid, s.serial#
3292: INTO l_session_id, l_serial_id
3293: FROM v$session s, v$process p
3294: WHERE s.paddr = p.addr
3295: AND audsid = USERENV('SESSIONID');
3296:
3297: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table