3411: into v_min_delivered
3412: , v_max_delivered
3413: from hr_s_user_tables;
3414:
3415: select pay_user_tables_s.nextval
3416: into v_sequence_number
3417: from dual;
3418:
3419: IF v_sequence_number
3419: IF v_sequence_number
3420: BETWEEN v_min_delivered AND v_max_delivered
3421: THEN
3422:
3423: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3424: v_sequence_number,
3425: v_max_delivered);
3426:
3427: END IF;
3474:
3475: EXCEPTION WHEN NO_DATA_FOUND THEN
3476:
3477:
3478: select pay_user_tables_s.nextval
3479: into l_new_surrogate_key
3480: from dual;
3481:
3482: WHEN TOO_MANY_ROWS THEN