DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_PAYMENT_TYPES_S

Line 4387: select pay_payment_types_s.nextval

4383: select max(payment_type_id)
4384: into v_max_live
4385: from pay_payment_types;
4386:
4387: select pay_payment_types_s.nextval
4388: into v_sequence_number
4389: from dual;
4390:
4391: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4392: OR (v_sequence_number < v_max_live) THEN
4393:
4394: IF v_max_live > v_max_delivered THEN
4395:
4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:

Line 4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:
4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4402: v_sequence_number,
4403: v_max_delivered);
4404: END IF;
4405: END IF;

Line 4450: select pay_payment_types_s.nextval

4446:
4447:
4448: EXCEPTION WHEN NO_DATA_FOUND THEN
4449:
4450: select pay_payment_types_s.nextval
4451: into l_new_surrogate_key
4452: from dual;
4453: END;
4454: