APPS.HR_LEGISLATION dependencies on PAY_BALANCE_DIMENSIONS_S

Line 2919: select pay_balance_dimensions_s.nextval

2915: select max(balance_dimension_id)
2916: into v_max_live
2917: from pay_balance_dimensions;
2918:
2919: select pay_balance_dimensions_s.nextval
2920: into v_sequence_number
2921: from dual;
2922:
2923: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2924: OR (v_sequence_number < v_max_live) THEN
2925:
2926: IF v_max_live > v_max_delivered THEN
2927:
2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:

Line 2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:
2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2934: v_sequence_number,
2935: v_max_delivered);
2936: END IF;
2937: END IF;

Line 2978: select pay_balance_dimensions_s.nextval

2974: or (legislation_code = stu_rec.c_leg_code) );
2975:
2976: EXCEPTION WHEN NO_DATA_FOUND THEN
2977:
2978: select pay_balance_dimensions_s.nextval
2979: into l_new_surrogate_key
2980: from dual;
2981:
2982: WHEN TOO_MANY_ROWS THEN