eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PYW2DATA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 136


     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;

Line: 197


   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');

Line: 205


   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');

Line: 212


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 218


   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);

Line: 392


   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');

Line: 400


   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');

Line: 407


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 413


   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);

Line: 429


   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);

Line: 445


   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);

Line: 461


   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);

Line: 477


   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);

Line: 493


   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);

Line: 509


   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);

Line: 525


   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);

Line: 541


   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);

Line: 557


   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);

Line: 573


   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);

Line: 589


   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);

Line: 605


   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);

Line: 621


   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);

Line: 637


   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);

Line: 653


   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);

Line: 669


   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);

Line: 685


   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);

Line: 701


   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);

Line: 717


   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);

Line: 733


   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);

Line: 749


   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);

Line: 765


   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);

Line: 781


   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);

Line: 797


   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);

Line: 813


   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);

Line: 829


   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);

Line: 845


   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);

Line: 1036


   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');

Line: 1044


   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');

Line: 1051


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 1057


   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);

Line: 1248


   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');

Line: 1256


   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');

Line: 1263


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 1269


   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);

Line: 1427


   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');

Line: 1435


   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');

Line: 1442


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 1448


   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);

Line: 1464


   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);

Line: 1622


   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');

Line: 1630


   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');

Line: 1638


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 1644


   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);

Line: 1801


   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');

Line: 1809


   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');

Line: 1816


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 1822


   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);

Line: 2013


   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');

Line: 2021


   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');

Line: 2028


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 2034


   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);

Line: 2237


   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');

Line: 2245


   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');

Line: 2252


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 2258


   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);

Line: 2428


   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');

Line: 2436


   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');

Line: 2443


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 2449


   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);

Line: 2633


   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');

Line: 2641


   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');

Line: 2648


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT
   and RFM.report_category = 'RT';

Line: 2654


   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);