DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_PAYMENT_TYPES_S

Line 4140: select pay_payment_types_s.nextval

4136: select max(payment_type_id)
4137: into v_max_live
4138: from pay_payment_types;
4139:
4140: select pay_payment_types_s.nextval
4141: into v_sequence_number
4142: from dual;
4143:
4144: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4145: OR (v_sequence_number < v_max_live) THEN
4146:
4147: IF v_max_live > v_max_delivered THEN
4148:
4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:

Line 4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:
4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4155: v_sequence_number,
4156: v_max_delivered);
4157: END IF;
4158: END IF;

Line 4203: select pay_payment_types_s.nextval

4199:
4200:
4201: EXCEPTION WHEN NO_DATA_FOUND THEN
4202:
4203: select pay_payment_types_s.nextval
4204: into l_new_surrogate_key
4205: from dual;
4206: END;
4207: