DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on DUAL

Line 526: select userenv('sessionid') sesid from dual;

522: FROM ghr_pa_requests
523: WHERE pa_request_id = c_pa_request_id;
524:
525: CURSOR c_sessionid is
526: select userenv('sessionid') sesid from dual;
527: -- Local Variables
528: l_sf52_rec ghr_pa_requests%rowtype;
529: l_new_line VARCHAR2(1);
530: l_log_text VARCHAR2(2000);