DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_USER_ROWS_S

Line 4487: select pay_user_rows_s.nextval

4483: select max(user_row_id)
4484: into v_max_live
4485: from pay_user_rows_f;
4486:
4487: select pay_user_rows_s.nextval
4488: into v_sequence_number
4489: from dual;
4490:
4491: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4496: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4492: OR (v_sequence_number < v_max_live) THEN
4493:
4494: IF v_max_live > v_max_delivered THEN
4495:
4496: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4497: v_sequence_number,
4498: v_max_live);
4499: ELSE
4500:

Line 4501: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4497: v_sequence_number,
4498: v_max_live);
4499: ELSE
4500:
4501: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4502: v_sequence_number,
4503: v_max_delivered);
4504: END IF;
4505: END IF;

Line 4577: select pay_user_rows_s.nextval

4573: and nvl(legislation_code, 'x') = nvl(r_distinct.legislation_code, 'x');
4574:
4575: EXCEPTION WHEN NO_DATA_FOUND THEN
4576:
4577: select pay_user_rows_s.nextval
4578: into l_new_user_row_id
4579: from dual;
4580: --
4581: WHEN TOO_MANY_ROWS THEN