DBA Data[Home] [Help]

APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on PER_GLOBAL_CWK_NUM_S

Line 18: g_cwk_sequence_name varchar2(30) := 'PER_GLOBAL_CWK_NUM_S';

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';

Line 848: select PER_GLOBAL_CWK_NUM_S.NEXTVAL

844: into l_next_value
845: from dual;
846:
847: elsif p_person_type = 'CWK' then
848: select PER_GLOBAL_CWK_NUM_S.NEXTVAL
849: into l_next_value
850: from dual;
851:
852: end if;