APPS.HR_LEGISLATION dependencies on PAY_BALANCE_CATEGORIES_S

Line 1164: select pay_balance_categories_s.nextval

1160: select max(BALANCE_CATEGORY_ID)
1161: into v_max_live
1162: from pay_balance_categories_f;
1163:
1164: select pay_balance_categories_s.nextval
1165: into v_sequence_number
1166: from dual;
1167:
1168: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1173: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1169: OR (v_sequence_number < v_max_live) THEN
1170:
1171: IF v_max_live > v_max_delivered THEN
1172:
1173: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1174: v_sequence_number,
1175: v_max_live);
1176: ELSE
1177:

Line 1178: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1174: v_sequence_number,
1175: v_max_live);
1176: ELSE
1177:
1178: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1179: v_sequence_number,
1180: v_max_delivered);
1181: END IF;
1182: END IF;

Line 1236: select pay_balance_categories_s.nextval

1232: and nvl(legislation_code, 'x') = nvl(r_distinct.legislation_code,'x');
1233:
1234: EXCEPTION WHEN NO_DATA_FOUND THEN
1235:
1236: select pay_balance_categories_s.nextval
1237: into l_new_balance_category_id
1238: from dual;
1239: --
1240: WHEN TOO_MANY_ROWS THEN