APPS.HR_LEGISLATION dependencies on PAY_BALANCE_TYPES_S

Line 1899: select pay_balance_types_s.nextval

1895: select max(balance_type_id)
1896: into v_max_live
1897: from pay_balance_types;
1898:
1899: select pay_balance_types_s.nextval
1900: into v_sequence_number
1901: from dual;
1902:
1903: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1904: OR (v_sequence_number < v_max_live) THEN
1905:
1906: IF v_max_live > v_max_delivered THEN
1907:
1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:

Line 1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:
1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1914: v_sequence_number,
1915: v_max_delivered);
1916: END IF;
1917: END IF;

Line 1994: select pay_balance_types_s.nextval

1990:
1991: EXCEPTION WHEN NO_DATA_FOUND THEN
1992:
1993:
1994: select pay_balance_types_s.nextval
1995: into l_new_surrogate_key
1996: from dual;
1997:
1998: v_new_balance_type_flag := 'Y';