APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on DUAL

Line 540: '.NEXTVAL FROM sys.dual';

536: -- -----------------------------------------------------------+
537: l_mynextval := 0;
538: l_currval := 0;
539: l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
540: '.NEXTVAL FROM sys.dual';
541:
542: EXECUTE IMMEDIATE l_string INTO l_mynextval;
543:
544: l_mynextval := l_mynextval - 1;

Line 576: '.nextval FROM sys.dual';

572: hr_utility.trace('Forcing sequence increment');
573: end if;
574: --
575: l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
576: '.nextval FROM sys.dual';
577:
578: EXECUTE IMMEDIATE l_string INTO l_mynextval;
579: l_alterflag := l_alterflag + 1;
580: -- ---------------------------------------+

Line 608: '.nextval FROM sys.dual';

604:
605: EXECUTE IMMEDIATE l_string;
606: --
607: l_string := 'SELECT ' || l_seq_owner || '.' || l_seq_name ||
608: '.nextval FROM sys.dual';
609:
610: EXECUTE IMMEDIATE l_string INTO l_mynextval;
611: -- return to previous settings
612: EXECUTE IMMEDIATE l_PrevSettings;

Line 847: from dual;

843: l_next_value := null;
844: if p_person_type = 'EMP' then
845: select PER_GLOBAL_EMP_NUM_S.NEXTVAL
846: into l_next_value
847: from dual;
848: elsif p_person_type = 'APL' then
849: select PER_GLOBAL_APL_NUM_S.NEXTVAL
850: into l_next_value
851: from dual;

Line 851: from dual;

847: from dual;
848: elsif p_person_type = 'APL' then
849: select PER_GLOBAL_APL_NUM_S.NEXTVAL
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

Line 856: 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;
859: if g_debug then
860: hr_utility.set_location(c_proc_name,20);