APPS.HR_LEGISLATION dependencies on PAY_BALANCE_CATEGORIES_S

Line 1369: select pay_balance_categories_s.nextval

1365: select max(BALANCE_CATEGORY_ID)
1366: into v_max_live
1367: from pay_balance_categories_f;
1368:
1369: select pay_balance_categories_s.nextval
1370: into v_sequence_number
1371: from dual;
1372:
1373: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1378: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1374: OR (v_sequence_number < v_max_live) THEN
1375:
1376: IF v_max_live > v_max_delivered THEN
1377:
1378: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1379: v_sequence_number,
1380: v_max_live);
1381: ELSE
1382:

Line 1383: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1379: v_sequence_number,
1380: v_max_live);
1381: ELSE
1382:
1383: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1384: v_sequence_number,
1385: v_max_delivered);
1386: END IF;
1387: END IF;

Line 1441: select pay_balance_categories_s.nextval

1437: and nvl(legislation_code, 'x') = nvl(r_distinct.legislation_code,'x');
1438:
1439: EXCEPTION WHEN NO_DATA_FOUND THEN
1440:
1441: select pay_balance_categories_s.nextval
1442: into l_new_balance_category_id
1443: from dual;
1444: --
1445: WHEN TOO_MANY_ROWS THEN