3379: into v_min_delivered
3380: , v_max_delivered
3381: from hr_s_user_tables;
3382:
3383: select pay_user_tables_s.nextval
3384: into v_sequence_number
3385: from dual;
3386:
3387: IF v_sequence_number
3387: IF v_sequence_number
3388: BETWEEN v_min_delivered AND v_max_delivered
3389: THEN
3390:
3391: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3392: v_sequence_number,
3393: v_max_delivered);
3394:
3395: END IF;
3442:
3443: EXCEPTION WHEN NO_DATA_FOUND THEN
3444:
3445:
3446: select pay_user_tables_s.nextval
3447: into l_new_surrogate_key
3448: from dual;
3449:
3450: WHEN TOO_MANY_ROWS THEN