Line 111: select userenv('sessionid') sesid from dual;
107:
108: ----SES Changes End
109:
110: cursor cur_sessionid is 111: select userenv('sessionid') sesid from dual; 112:
113: cursor get_sal_chg_fam(p_effective_date in date) is
114: select NOA_FAMILY_CODE
115: from ghr_families