APPS.HR_LEGISLATION dependencies on PAY_MAGNETIC_BLOCKS_S

Line 6051: select pay_magnetic_blocks_s.nextval

6047: select max(magnetic_block_id)
6048: into v_max_live
6049: from pay_magnetic_blocks;
6050:
6051: select pay_magnetic_blocks_s.nextval
6052: into v_sequence_number
6053: from dual;
6054:
6055: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6056: OR (v_sequence_number < v_max_live) THEN
6057:
6058: IF v_max_live > v_max_delivered THEN
6059:
6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:

Line 6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:
6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6066: v_sequence_number,
6067: v_max_delivered);
6068: END IF;
6069: END IF;

Line 6118: select pay_magnetic_blocks_s.nextval

6114: replace(ltrim(rtrim(upper(nvl(stu_rec.cursor_name,'X')))), ' ', '_');
6115:
6116: EXCEPTION WHEN NO_DATA_FOUND THEN
6117:
6118: select pay_magnetic_blocks_s.nextval
6119: into l_new_surrogate_key
6120: from dual;
6121:
6122: WHEN TOO_MANY_ROWS THEN