APPS.HR_LEGISLATION dependencies on PAY_MAGNETIC_BLOCKS_S

Line 5801: select pay_magnetic_blocks_s.nextval

5797: select max(magnetic_block_id)
5798: into v_max_live
5799: from pay_magnetic_blocks;
5800:
5801: select pay_magnetic_blocks_s.nextval
5802: into v_sequence_number
5803: from dual;
5804:
5805: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5806: OR (v_sequence_number < v_max_live) THEN
5807:
5808: IF v_max_live > v_max_delivered THEN
5809:
5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:

Line 5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:
5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5816: v_sequence_number,
5817: v_max_delivered);
5818: END IF;
5819: END IF;

Line 5868: select pay_magnetic_blocks_s.nextval

5864: replace(ltrim(rtrim(upper(nvl(stu_rec.cursor_name,'X')))), ' ', '_');
5865:
5866: EXCEPTION WHEN NO_DATA_FOUND THEN
5867:
5868: select pay_magnetic_blocks_s.nextval
5869: into l_new_surrogate_key
5870: from dual;
5871:
5872: WHEN TOO_MANY_ROWS THEN