APPS.PSA_BC_XML_REPORT_PUB dependencies on V$SESSION

Line 3370: FROM v$session

3366:
3367: DELETE FROM psa_bc_xml_clob pbxc
3368: WHERE (((SYSDATE - pbxc.creation_date) > 1) OR
3369: (NOT EXISTS (SELECT 'x'
3370: FROM v$session
3371: WHERE audsid = pbxc.session_id
3372: AND Serial# = pbxc.serial_id)));
3373:
3374: psa_utils.debug_other_string(g_state_level,l_api_name,

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

3376:
3377:
3378: SELECT s.audsid, s.serial#
3379: INTO l_session_id, l_serial_id
3380: FROM v$session s, v$process p
3381: WHERE s.paddr = p.addr
3382: AND audsid = USERENV('SESSIONID');
3383:
3384: -- Inserting the XML CLOB value into PSA_BC_XML_CLOB table