DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_DEFINED_BALANCES_S

Line 1926: select pay_defined_balances_s.nextval

1922: into v_min_delivered
1923: , v_max_delivered
1924: from hr_s_defined_balances;
1925:
1926: select pay_defined_balances_s.nextval
1927: into v_sequence_number
1928: from dual;
1929:
1930: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN

Line 1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',

1928: from dual;
1929:
1930: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN
1931:
1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',
1933: v_sequence_number,
1934: v_max_delivered);
1935:
1936: END IF;

Line 2056: select pay_defined_balances_s.nextval

2052: or (legislation_code = def_bals.legislation_code) );
2053:
2054: EXCEPTION WHEN NO_DATA_FOUND THEN
2055:
2056: select pay_defined_balances_s.nextval
2057: into v_new_def_bal_id
2058: from dual;
2059:
2060: WHEN TOO_MANY_ROWS THEN