APPS.HR_LEGISLATION dependencies on HR_S_MAGNETIC_BLOCKS

Line 5991: from hr_s_magnetic_blocks;

5987: main_block_flag,
5988: report_format,
5989: cursor_name,
5990: no_column_returned
5991: from hr_s_magnetic_blocks;
5992:
5993: stu_rec stu%ROWTYPE;
5994:
5995:

Line 6014: from hr_s_magnetic_blocks;

6010: --with the delivered values
6011:
6012: select count(*)
6013: into cnt
6014: from hr_s_magnetic_blocks;
6015:
6016: If cnt=0 then return; end if;
6017:
6018: select distinct null

Line 6023: from hr_s_magnetic_blocks b

6019: into l_null_return
6020: from pay_magnetic_blocks a
6021: where exists
6022: (select null
6023: from hr_s_magnetic_blocks b
6024: where a.magnetic_block_id = b.magnetic_block_id
6025: );
6026:
6027: update hr_s_magnetic_blocks

Line 6027: update hr_s_magnetic_blocks

6023: from hr_s_magnetic_blocks b
6024: where a.magnetic_block_id = b.magnetic_block_id
6025: );
6026:
6027: update hr_s_magnetic_blocks
6028: set magnetic_block_id=magnetic_block_id -50000000;
6029:
6030: update hr_s_magnetic_records
6031: set magnetic_block_id=magnetic_block_id -50000000;

Line 6045: from hr_s_magnetic_blocks;

6041: select min(magnetic_block_id) - (count(*) *3)
6042: , max(magnetic_block_id) + (count(*) *3)
6043: into v_min_delivered
6044: , v_max_delivered
6045: from hr_s_magnetic_blocks;
6046:
6047: select max(magnetic_block_id)
6048: into v_max_live
6049: from pay_magnetic_blocks;

Line 6137: update hr_s_magnetic_blocks

6133: END;
6134:
6135: -- Update all child entities
6136:
6137: update hr_s_magnetic_blocks
6138: set magnetic_block_id = l_new_surrogate_key
6139: where magnetic_block_id = stu_rec.c_surrogate_key;
6140:
6141: update hr_s_application_ownerships

Line 6163: delete from hr_s_magnetic_blocks

6159: -- Remove a row from either the startup tables or the installed tables
6160:
6161: BEGIN
6162:
6163: delete from hr_s_magnetic_blocks
6164: where magnetic_block_id = stu_rec.c_surrogate_key;
6165:
6166: END remove;
6167: