36: where session_id = userenv('SESSIONID');
37: --
38: cursor get_system_date IS
39: select trunc(sysdate)
40: from dual;
41: --
42: cursor get_ler(l_status varchar2) is
43: select ler.ler_id
44: , ler.typ_cd
415: where session_id = userenv('SESSIONID');
416: --
417: cursor get_system_date IS
418: select trunc(sysdate)
419: from dual;
420: --
421: cursor get_ler(l_status varchar2) is
422: select ler.ler_id
423: , ler.typ_cd