APPS.MSC_ATP_PVT dependencies on V$SESSION

Line 19008: WHERE addr = (SELECT paddr FROM v$session

19004: -- rajjain 12/20/2002
19005: SELECT spid
19006: INTO l_spid
19007: FROM v$process
19008: WHERE addr = (SELECT paddr FROM v$session
19009: WHERE audsid=userenv('SESSIONID'));
19010: x_spid_des := l_spid; --ATP Debug Workflow
19011:
19012: SELECT value

Line 19177: WHERE addr = (SELECT paddr FROM v$session

19173: -- rajjain 12/20/2002
19174: SELECT spid
19175: INTO l_spid
19176: FROM v$process
19177: WHERE addr = (SELECT paddr FROM v$session
19178: WHERE audsid=userenv('SESSIONID'));
19179: IF PG_DEBUG in ('Y', 'C') THEN
19180: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'spid: ' || l_spid);
19181: END IF;