The following lines contain the word 'select', 'insert', 'update' or 'delete':
select FM.formula_id
from ff_formulas_f FM
where FM.legislation_code = p_legislation_code
and FM.formula_name = upper(p_formula_name)
and p_session_date between FM.effective_start_date
and FM.effective_end_date;
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'FED', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'AL', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'AZ', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'AR', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'CO', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'DE', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'DC', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'GA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'ID', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'IL', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'IA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'KS', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'ME', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MD', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MN', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MO', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MT', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'NE', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'NM', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'ND', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'OK', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'PA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'PR', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'RI', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'SC', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'UT', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'VA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'WI', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'NJ', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'WV', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MI', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'LA', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'KY', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'MS', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'IN', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'CT', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'OH', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
delete from pay_magnetic_records MGR
where MGR.magnetic_block_id in (select MGB.magnetic_block_id
from pay_magnetic_blocks MGB,
pay_report_format_mappings_f RFM
where MGB.report_format = RFM.report_format
AND RFM.report_format = L_REPORT_FORMAT
AND RFM.report_category = 'RT');
delete from pay_magnetic_blocks MGB
where MGB.report_format in (
SELECT report_format
FROM pay_report_format_mappings_f
WHERE report_format = L_REPORT_FORMAT
AND report_category = 'RT');
delete from pay_report_format_mappings_f RFM
where RFM.report_format = L_REPORT_FORMAT
and RFM.report_category = 'RT';
insert into pay_report_format_mappings_f
( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
RANGE_CODE,
ASSIGNMENT_ACTION_CODE,
INITIALIZATION_CODE,
ARCHIVE_CODE,
MAGNETIC_CODE,
REPORT_FORMAT, EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE )
values ('W2' , 'NC', 'RT',
'pay_us_magw2_reporting.range_cursor',
'pay_us_magw2_reporting.create_assignment_act',
NULL,
NULL,
'pay_magtape_generic.new_formula',
L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);