APPS.HR_LEGISLATION dependencies on PAY_BALANCE_TYPES_S

Line 1694: select pay_balance_types_s.nextval

1690: select max(balance_type_id)
1691: into v_max_live
1692: from pay_balance_types;
1693:
1694: select pay_balance_types_s.nextval
1695: into v_sequence_number
1696: from dual;
1697:
1698: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1699: OR (v_sequence_number < v_max_live) THEN
1700:
1701: IF v_max_live > v_max_delivered THEN
1702:
1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:

Line 1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:
1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1709: v_sequence_number,
1710: v_max_delivered);
1711: END IF;
1712: END IF;

Line 1777: select pay_balance_types_s.nextval

1773:
1774: EXCEPTION WHEN NO_DATA_FOUND THEN
1775:
1776:
1777: select pay_balance_types_s.nextval
1778: into l_new_surrogate_key
1779: from dual;
1780:
1781: v_new_balance_type_flag := 'Y';