APPS.HR_UTILITY dependencies on V$SESSION

Line 514: v$session s

510: l_retval number := null ;
511: cursor getpid is
512: select p.pid
513: from v$process p,
514: v$session s
515: where s.paddr = p.addr
516: and s.audsid = userenv('sessionid');
517: begin
518:

Line 999: from v$session

995: l_dummy varchar2(2000);
996:
997: cursor get_session is
998: select 1
999: from v$session
1000: where audsid = replace(p_pipename,'PIPE')
1001: and status <> 'KILLED' ;
1002:
1003: begin

Line 1078: from v$session

1074: complete boolean;
1075: --
1076: cursor get_session is
1077: select 1
1078: from v$session
1079: where audsid = replace(p_pipename,'PIPE')
1080: and status <> 'KILLED' ;
1081: --
1082: begin