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.PYSQDATA SQL Statements

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

Line: 25


                 meshah     contd.  Inserted the formula definition for Iowa Tape(ICESA).
 12-mar-1999     VMehta     40.4    Removed the Diskette formats for CA, FL, TX
												ID, OK, NJ and MS. Will be provided at a
												later date
                                    Modified format for Connecticut.
 16-mar-1999     VMehta     40.5(110.1)    Added FTP format for Illinois
 ***************************************************************************

 ============================================================================*/
 --
 -- Date constants representing the start and end of time.sqlk
 --
 START_OF_TIME constant date := to_date('01/01/0001','DD/MM/YYYY');

Line: 64


     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: 125


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 130


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 133


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 140


   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 ('SQWL'  , 'AL', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 157


   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 ('SQWL'  , 'AZ', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 174


   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 ('SQWL'  , 'CA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 191


   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 ('SQWL'  , 'CO', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 208


   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 ('SQWL'  , 'IA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 225


   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 ('SQWL'  , 'IL', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 242


   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 ('SQWL' ,  'IN', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 259


   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 ('SQWL'  , 'KS', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 276


   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 ('SQWL'  , 'ME', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 293


   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 ('SQWL'  , 'KY', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 310


   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 ('SQWL'  , 'MD', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 327


   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 ('SQWL'  , 'MA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 344


   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 ('SQWL'  , 'MN', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 361


   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 ('SQWL'  , 'MO', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 378


   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 ('SQWL'  , 'MT', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 395


   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 ('SQWL'  , 'NV', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 412


   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 ('SQWL'  , 'NC', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   '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 ('SQWL'  , 'OK', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 446


   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 ('SQWL'  , 'PA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 463


   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 ('SQWL'  , 'SC', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 480


   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 ('SQWL'  , 'SD', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 497


   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 ('SQWL'  , 'TN', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 514


   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 ('SQWL'  , 'TX', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 531


   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 ('SQWL'  , 'VT', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 548


   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 ('SQWL'  , 'WV', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 691


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 696


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 699


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 707


   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 ('SQWL'  , 'AR', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 724


   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 ('SQWL'  , 'DE', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 741


   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 ('SQWL'  , 'LA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 758


   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 ('SQWL'  , 'NE', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 775


   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 ('SQWL'  , 'NH', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 792


   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 ('SQWL'  , 'OR', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 810


   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 ('SQWL'  , 'UT', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 827


   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 ('SQWL'  , 'VA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 844


   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 ('SQWL'  , 'WI', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 979


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 984


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 987


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 992


   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 ('SQWL' ,  'ND', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1120


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1125


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1128


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1133


   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 ('SQWL' ,  'AK', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1249


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1254


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1257


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1262


   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 ('SQWL' ,  'ID', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1377


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1382


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1385


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1390


   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 ('SQWL' ,  'DC', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1506


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1511


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1514


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1519


   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 ('SQWL' ,  'PR', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1635


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1640


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1643


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1648


   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 ('SQWL' ,  'IN', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1765


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1770


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1773


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1778


   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 ('SQWL' ,  'NJ', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 1895


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 1900


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 1903


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 1908


   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 ('SQWL' ,  'GA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2024


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2029


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2032


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2037


   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 ('SQWL' ,  'NM', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2153


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2158


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2161


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2166


   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 ('SQWL' ,  'NY', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2286


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2291


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2294


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2299


   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 ('SQWL' ,  'OH', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2418


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2423


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2426


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2431


   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 ('SQWL'  , 'IA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2582


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);   --

Line: 2586


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2589


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2594


   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 ('SQWL'  , 'FL', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2733


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2738


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2741


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2746


   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 ('SQWL' ,  'RI', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2865


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2870


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 2873


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 2878


   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 ('SQWL' ,  'WY', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 2993


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 2998


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3001


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3006


   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 ('SQWL' ,  'MI', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3120


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3125


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3128


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3133


   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 ('SQWL' ,  'HI', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3250


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3255


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3258


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3263


   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 ('SQWL' ,  'WA', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3378


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3383


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3386


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3391


   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 ('SQWL' ,  'CT', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3505


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3510


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3513


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3518


   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 ('SQWL' ,  'MS', 'RT',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3632


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3637


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3640


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3645


   insert into pay_report_format_mappings_f
          (REPORT_TYPE,
           REPORT_QUALIFIER,
           REPORT_CATEGORY,
           REPORT_FORMAT,
		   RANGE_CODE,
		   ASSIGNMENT_ACTION_CODE,
		   INITIALIZATION_CODE,
		   ARCHIVE_CODE,
		   MAGNETIC_CODE,
           EFFECTIVE_START_DATE,
           EFFECTIVE_END_DATE)
   values ('SQWL' ,  'SD', 'PD', L_REPORT_FORMAT,
		   'pay_us_archive.range_cursor',
		   'pay_us_archive.action_creation',
		   'pay_us_archive.archinit',
		   'pay_us_archive.archive_data',
		   'pay_magtape_generic.new_formula',
			START_OF_TIME, END_OF_TIME);

Line: 3762


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3767


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3770


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3775


   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 ('SQWL' ,  'MD', 'PD',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 3888


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 3893


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 3896


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 3902


   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 ('SQWL'  , 'IL', 'PD',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4041


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4046


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4049


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4055


   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 ('SQWL'  , 'LA', 'RTLAQ',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4182


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4187


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4190


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4196


   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 ('SQWL'  , 'OR', 'FTP',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4324


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4329


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4332


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4337


   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 ('SQWL' ,  'ND', 'FTP',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4465


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4470


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4473


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4480


   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 ('SQWL'  , 'AL', 'FTP',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4497


  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 ('SQWL'  , 'IL', 'FTP',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4514


   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 ('SQWL'  , 'NC', 'FTP',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4531


   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 ('SQWL'  , 'WV', 'PD',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4671


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
				    from   pay_magnetic_blocks MGB
				    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4676


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4679


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4684


   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 ('SQWL' ,  'MS', 'PD',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);

Line: 4798


   delete from pay_magnetic_records MGR
   where  MGR.magnetic_block_id in (select MGB.magnetic_block_id
                                    from   pay_magnetic_blocks MGB
                                    where  MGB.report_format = L_REPORT_FORMAT);

Line: 4803


   delete from pay_magnetic_blocks MGB
   where  MGB.report_format = L_REPORT_FORMAT;

Line: 4806


   delete from pay_report_format_mappings_f RFM
   where  RFM.report_format = L_REPORT_FORMAT;

Line: 4811


   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 ('SQWL' ,  'WY', 'PD',
   'pay_us_archive.range_cursor',
   'pay_us_archive.action_creation',
   'pay_us_archive.archinit',
   'pay_us_archive.archive_data',
   'pay_magtape_generic.new_formula',
   L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);