APPS.HR_LEGISLATION dependencies on PAY_MONETARY_UNITS_S

Line 5240: select pay_monetary_units_s.nextval

5236: select max(monetary_unit_id)
5237: into v_max_live
5238: from pay_monetary_units;
5239:
5240: select pay_monetary_units_s.nextval
5241: into v_sequence_number
5242: from dual;
5243:
5244: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 5249: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5245: OR (v_sequence_number < v_max_live) THEN
5246:
5247: IF v_max_live > v_max_delivered THEN
5248:
5249: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5250: v_sequence_number,
5251: v_max_live);
5252: ELSE
5253:

Line 5254: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5250: v_sequence_number,
5251: v_max_live);
5252: ELSE
5253:
5254: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5255: v_sequence_number,
5256: v_max_delivered);
5257: END IF;
5258: END IF;

Line 5284: select pay_monetary_units_s.nextval

5280: );
5281:
5282: EXCEPTION WHEN NO_DATA_FOUND THEN
5283:
5284: select pay_monetary_units_s.nextval
5285: into l_new_surrogate_key
5286: from dual;
5287:
5288: END;