DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_USER_ROWS_S

Line 4737: select pay_user_rows_s.nextval

4733: select max(user_row_id)
4734: into v_max_live
4735: from pay_user_rows_f;
4736:
4737: select pay_user_rows_s.nextval
4738: into v_sequence_number
4739: from dual;
4740:
4741: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4746: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4742: OR (v_sequence_number < v_max_live) THEN
4743:
4744: IF v_max_live > v_max_delivered THEN
4745:
4746: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4747: v_sequence_number,
4748: v_max_live);
4749: ELSE
4750:

Line 4751: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4747: v_sequence_number,
4748: v_max_live);
4749: ELSE
4750:
4751: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4752: v_sequence_number,
4753: v_max_delivered);
4754: END IF;
4755: END IF;

Line 4827: select pay_user_rows_s.nextval

4823: and nvl(legislation_code, 'x') = nvl(r_distinct.legislation_code, 'x');
4824:
4825: EXCEPTION WHEN NO_DATA_FOUND THEN
4826:
4827: select pay_user_rows_s.nextval
4828: into l_new_user_row_id
4829: from dual;
4830: --
4831: WHEN TOO_MANY_ROWS THEN