APPS.HR_LEGISLATION dependencies on PAY_BALANCE_DIMENSIONS_S

Line 2673: select pay_balance_dimensions_s.nextval

2669: select max(balance_dimension_id)
2670: into v_max_live
2671: from pay_balance_dimensions;
2672:
2673: select pay_balance_dimensions_s.nextval
2674: into v_sequence_number
2675: from dual;
2676:
2677: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2678: OR (v_sequence_number < v_max_live) THEN
2679:
2680: IF v_max_live > v_max_delivered THEN
2681:
2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:

Line 2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:
2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2688: v_sequence_number,
2689: v_max_delivered);
2690: END IF;
2691: END IF;

Line 2732: select pay_balance_dimensions_s.nextval

2728: or (legislation_code = stu_rec.c_leg_code) );
2729:
2730: EXCEPTION WHEN NO_DATA_FOUND THEN
2731:
2732: select pay_balance_dimensions_s.nextval
2733: into l_new_surrogate_key
2734: from dual;
2735:
2736: WHEN TOO_MANY_ROWS THEN