APPS.HR_LEGISLATION dependencies on HR_S_MAGNETIC_BLOCKS

Line 5741: from hr_s_magnetic_blocks;

5737: main_block_flag,
5738: report_format,
5739: cursor_name,
5740: no_column_returned
5741: from hr_s_magnetic_blocks;
5742:
5743: stu_rec stu%ROWTYPE;
5744:
5745:

Line 5764: from hr_s_magnetic_blocks;

5760: --with the delivered values
5761:
5762: select count(*)
5763: into cnt
5764: from hr_s_magnetic_blocks;
5765:
5766: If cnt=0 then return; end if;
5767:
5768: select distinct null

Line 5773: from hr_s_magnetic_blocks b

5769: into l_null_return
5770: from pay_magnetic_blocks a
5771: where exists
5772: (select null
5773: from hr_s_magnetic_blocks b
5774: where a.magnetic_block_id = b.magnetic_block_id
5775: );
5776:
5777: update hr_s_magnetic_blocks

Line 5777: update hr_s_magnetic_blocks

5773: from hr_s_magnetic_blocks b
5774: where a.magnetic_block_id = b.magnetic_block_id
5775: );
5776:
5777: update hr_s_magnetic_blocks
5778: set magnetic_block_id=magnetic_block_id -50000000;
5779:
5780: update hr_s_magnetic_records
5781: set magnetic_block_id=magnetic_block_id -50000000;

Line 5795: from hr_s_magnetic_blocks;

5791: select min(magnetic_block_id) - (count(*) *3)
5792: , max(magnetic_block_id) + (count(*) *3)
5793: into v_min_delivered
5794: , v_max_delivered
5795: from hr_s_magnetic_blocks;
5796:
5797: select max(magnetic_block_id)
5798: into v_max_live
5799: from pay_magnetic_blocks;

Line 5887: update hr_s_magnetic_blocks

5883: END;
5884:
5885: -- Update all child entities
5886:
5887: update hr_s_magnetic_blocks
5888: set magnetic_block_id = l_new_surrogate_key
5889: where magnetic_block_id = stu_rec.c_surrogate_key;
5890:
5891: update hr_s_application_ownerships

Line 5913: delete from hr_s_magnetic_blocks

5909: -- Remove a row from either the startup tables or the installed tables
5910:
5911: BEGIN
5912:
5913: delete from hr_s_magnetic_blocks
5914: where magnetic_block_id = stu_rec.c_surrogate_key;
5915:
5916: END remove;
5917: