DBA Data[Home] [Help]

APPS.CSD_GEN_UTILITY_PVT dependencies on V$SESSION

Line 14: FROM v$session

10: IF csd_gen_utility_pvt.g_file IS NULL THEN
11: SELECT USERENV('SESSIONID') INTO l_audsid FROM sys.dual;
12:
13: SELECT sid, SUBSTR(osuser,1,8) INTO l_sid ,l_os_user
14: FROM v$session
15: WHERE audsid = l_audsid;
16:
17: SELECT l_os_user||'.csd'||TO_CHAR(l_sid)||'.dbg'
18: INTO csd_gen_utility_pvt.g_file