DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_MONETARY_UNITS_S

Line 5490: select pay_monetary_units_s.nextval

5486: select max(monetary_unit_id)
5487: into v_max_live
5488: from pay_monetary_units;
5489:
5490: select pay_monetary_units_s.nextval
5491: into v_sequence_number
5492: from dual;
5493:
5494: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 5499: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5495: OR (v_sequence_number < v_max_live) THEN
5496:
5497: IF v_max_live > v_max_delivered THEN
5498:
5499: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5500: v_sequence_number,
5501: v_max_live);
5502: ELSE
5503:

Line 5504: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5500: v_sequence_number,
5501: v_max_live);
5502: ELSE
5503:
5504: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5505: v_sequence_number,
5506: v_max_delivered);
5507: END IF;
5508: END IF;

Line 5534: select pay_monetary_units_s.nextval

5530: );
5531:
5532: EXCEPTION WHEN NO_DATA_FOUND THEN
5533:
5534: select pay_monetary_units_s.nextval
5535: into l_new_surrogate_key
5536: from dual;
5537:
5538: END;