14: --
15: -- Enh 2931775
16: g_emp_sequence_name varchar2(30) := 'PER_GLOBAL_EMP_NUM_S';
17: g_apl_sequence_name varchar2(30) := 'PER_GLOBAL_APL_NUM_S';
18: g_cwk_sequence_name varchar2(30) := 'PER_GLOBAL_CWK_NUM_S';
19: --
20: g_xbg_EMPNum_profile varchar2(30) := 'PER_GLOBAL_EMP_NUM';
21: g_xbg_APLNum_profile varchar2(30) := 'PER_GLOBAL_APL_NUM';
22: g_xbg_CWKNum_profile varchar2(30) := 'PER_GLOBAL_CWK_NUM';
850: into l_next_value
851: from dual;
852:
853: elsif p_person_type = 'CWK' then
854: select PER_GLOBAL_CWK_NUM_S.NEXTVAL
855: into l_next_value
856: from dual;
857:
858: end if;