[Home] [Help]
59:
60: 15-JUL-98 vmehta Moved 'KY' from SSA format to ICESA
61: for SQWL
62: 22-JUL-98 vmehta Added code to populate 'magtape resilience'
63: data in pay_report_format_mappings_f
64: Folded in changes from patch 702840.
65: New formulae for Washington SQWL
66: New Format definition for Connecticut
67: SQWL (bug 704503)
196: --
197: delete from pay_magnetic_records MGR
198: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
199: from pay_magnetic_blocks MGB,
200: pay_report_format_mappings_f RFM
201: where MGB.report_format = RFM.report_format
202: AND RFM.report_format = L_REPORT_FORMAT
203: AND RFM.report_category = 'RT');
204: --
204: --
205: delete from pay_magnetic_blocks MGB
206: where MGB.report_format in (
207: SELECT report_format
208: FROM pay_report_format_mappings_f
209: WHERE report_format = L_REPORT_FORMAT
210: AND report_category = 'RT');
211: --
212: delete from pay_report_format_mappings_f RFM
208: FROM pay_report_format_mappings_f
209: WHERE report_format = L_REPORT_FORMAT
210: AND report_category = 'RT');
211: --
212: delete from pay_report_format_mappings_f RFM
213: where RFM.report_format = L_REPORT_FORMAT
214: and RFM.report_category = 'RT';
215: --
216: -- Report to format definitions.
214: and RFM.report_category = 'RT';
215: --
216: -- Report to format definitions.
217: --
218: insert into pay_report_format_mappings_f
219: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
220: RANGE_CODE,
221: ASSIGNMENT_ACTION_CODE,
222: INITIALIZATION_CODE,
391: --
392: delete from pay_magnetic_records MGR
393: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
394: from pay_magnetic_blocks MGB,
395: pay_report_format_mappings_f RFM
396: where MGB.report_format = RFM.report_format
397: AND RFM.report_format = L_REPORT_FORMAT
398: AND RFM.report_category = 'RT');
399: --
399: --
400: delete from pay_magnetic_blocks MGB
401: where MGB.report_format in (
402: SELECT report_format
403: FROM pay_report_format_mappings_f
404: WHERE report_format = L_REPORT_FORMAT
405: AND report_category = 'RT');
406: --
407: delete from pay_report_format_mappings_f RFM
403: FROM pay_report_format_mappings_f
404: WHERE report_format = L_REPORT_FORMAT
405: AND report_category = 'RT');
406: --
407: delete from pay_report_format_mappings_f RFM
408: where RFM.report_format = L_REPORT_FORMAT
409: and RFM.report_category = 'RT';
410: --
411: -- Report to format definitions.
409: and RFM.report_category = 'RT';
410: --
411: -- Report to format definitions.
412: --
413: insert into pay_report_format_mappings_f
414: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
415: RANGE_CODE,
416: ASSIGNMENT_ACTION_CODE,
417: INITIALIZATION_CODE,
425: NULL,
426: NULL,
427: 'pay_magtape_generic.new_formula',
428: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
429: insert into pay_report_format_mappings_f
430: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
431: RANGE_CODE,
432: ASSIGNMENT_ACTION_CODE,
433: INITIALIZATION_CODE,
441: NULL,
442: NULL,
443: 'pay_magtape_generic.new_formula',
444: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
445: insert into pay_report_format_mappings_f
446: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
447: RANGE_CODE,
448: ASSIGNMENT_ACTION_CODE,
449: INITIALIZATION_CODE,
457: NULL,
458: NULL,
459: 'pay_magtape_generic.new_formula',
460: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
461: insert into pay_report_format_mappings_f
462: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
463: RANGE_CODE,
464: ASSIGNMENT_ACTION_CODE,
465: INITIALIZATION_CODE,
473: NULL,
474: NULL,
475: 'pay_magtape_generic.new_formula',
476: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
477: insert into pay_report_format_mappings_f
478: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
479: RANGE_CODE,
480: ASSIGNMENT_ACTION_CODE,
481: INITIALIZATION_CODE,
489: NULL,
490: NULL,
491: 'pay_magtape_generic.new_formula',
492: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
493: insert into pay_report_format_mappings_f
494: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
495: RANGE_CODE,
496: ASSIGNMENT_ACTION_CODE,
497: INITIALIZATION_CODE,
505: NULL,
506: NULL,
507: 'pay_magtape_generic.new_formula',
508: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
509: insert into pay_report_format_mappings_f
510: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
511: RANGE_CODE,
512: ASSIGNMENT_ACTION_CODE,
513: INITIALIZATION_CODE,
521: NULL,
522: NULL,
523: 'pay_magtape_generic.new_formula',
524: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
525: insert into pay_report_format_mappings_f
526: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
527: RANGE_CODE,
528: ASSIGNMENT_ACTION_CODE,
529: INITIALIZATION_CODE,
537: NULL,
538: NULL,
539: 'pay_magtape_generic.new_formula',
540: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
541: insert into pay_report_format_mappings_f
542: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
543: RANGE_CODE,
544: ASSIGNMENT_ACTION_CODE,
545: INITIALIZATION_CODE,
553: NULL,
554: NULL,
555: 'pay_magtape_generic.new_formula',
556: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
557: insert into pay_report_format_mappings_f
558: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
559: RANGE_CODE,
560: ASSIGNMENT_ACTION_CODE,
561: INITIALIZATION_CODE,
569: NULL,
570: NULL,
571: 'pay_magtape_generic.new_formula',
572: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
573: insert into pay_report_format_mappings_f
574: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
575: RANGE_CODE,
576: ASSIGNMENT_ACTION_CODE,
577: INITIALIZATION_CODE,
585: NULL,
586: NULL,
587: 'pay_magtape_generic.new_formula',
588: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
589: insert into pay_report_format_mappings_f
590: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
591: RANGE_CODE,
592: ASSIGNMENT_ACTION_CODE,
593: INITIALIZATION_CODE,
601: NULL,
602: NULL,
603: 'pay_magtape_generic.new_formula',
604: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
605: insert into pay_report_format_mappings_f
606: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
607: RANGE_CODE,
608: ASSIGNMENT_ACTION_CODE,
609: INITIALIZATION_CODE,
617: NULL,
618: NULL,
619: 'pay_magtape_generic.new_formula',
620: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
621: insert into pay_report_format_mappings_f
622: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
623: RANGE_CODE,
624: ASSIGNMENT_ACTION_CODE,
625: INITIALIZATION_CODE,
633: NULL,
634: NULL,
635: 'pay_magtape_generic.new_formula',
636: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
637: insert into pay_report_format_mappings_f
638: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
639: RANGE_CODE,
640: ASSIGNMENT_ACTION_CODE,
641: INITIALIZATION_CODE,
649: NULL,
650: NULL,
651: 'pay_magtape_generic.new_formula',
652: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
653: insert into pay_report_format_mappings_f
654: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
655: RANGE_CODE,
656: ASSIGNMENT_ACTION_CODE,
657: INITIALIZATION_CODE,
665: NULL,
666: NULL,
667: 'pay_magtape_generic.new_formula',
668: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
669: insert into pay_report_format_mappings_f
670: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
671: RANGE_CODE,
672: ASSIGNMENT_ACTION_CODE,
673: INITIALIZATION_CODE,
681: NULL,
682: NULL,
683: 'pay_magtape_generic.new_formula',
684: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
685: insert into pay_report_format_mappings_f
686: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
687: RANGE_CODE,
688: ASSIGNMENT_ACTION_CODE,
689: INITIALIZATION_CODE,
697: NULL,
698: NULL,
699: 'pay_magtape_generic.new_formula',
700: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
701: insert into pay_report_format_mappings_f
702: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
703: RANGE_CODE,
704: ASSIGNMENT_ACTION_CODE,
705: INITIALIZATION_CODE,
713: NULL,
714: NULL,
715: 'pay_magtape_generic.new_formula',
716: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
717: insert into pay_report_format_mappings_f
718: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
719: RANGE_CODE,
720: ASSIGNMENT_ACTION_CODE,
721: INITIALIZATION_CODE,
729: NULL,
730: NULL,
731: 'pay_magtape_generic.new_formula',
732: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
733: insert into pay_report_format_mappings_f
734: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
735: RANGE_CODE,
736: ASSIGNMENT_ACTION_CODE,
737: INITIALIZATION_CODE,
745: NULL,
746: NULL,
747: 'pay_magtape_generic.new_formula',
748: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
749: insert into pay_report_format_mappings_f
750: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
751: RANGE_CODE,
752: ASSIGNMENT_ACTION_CODE,
753: INITIALIZATION_CODE,
761: NULL,
762: NULL,
763: 'pay_magtape_generic.new_formula',
764: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
765: insert into pay_report_format_mappings_f
766: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
767: RANGE_CODE,
768: ASSIGNMENT_ACTION_CODE,
769: INITIALIZATION_CODE,
777: NULL,
778: NULL,
779: 'pay_magtape_generic.new_formula',
780: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
781: insert into pay_report_format_mappings_f
782: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
783: RANGE_CODE,
784: ASSIGNMENT_ACTION_CODE,
785: INITIALIZATION_CODE,
793: NULL,
794: NULL,
795: 'pay_magtape_generic.new_formula',
796: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
797: insert into pay_report_format_mappings_f
798: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
799: RANGE_CODE,
800: ASSIGNMENT_ACTION_CODE,
801: INITIALIZATION_CODE,
809: NULL,
810: NULL,
811: 'pay_magtape_generic.new_formula',
812: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
813: insert into pay_report_format_mappings_f
814: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
815: RANGE_CODE,
816: ASSIGNMENT_ACTION_CODE,
817: INITIALIZATION_CODE,
825: NULL,
826: NULL,
827: 'pay_magtape_generic.new_formula',
828: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
829: insert into pay_report_format_mappings_f
830: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
831: RANGE_CODE,
832: ASSIGNMENT_ACTION_CODE,
833: INITIALIZATION_CODE,
841: NULL,
842: NULL,
843: 'pay_magtape_generic.new_formula',
844: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
845: insert into pay_report_format_mappings_f
846: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
847: RANGE_CODE,
848: ASSIGNMENT_ACTION_CODE,
849: INITIALIZATION_CODE,
1035: --
1036: delete from pay_magnetic_records MGR
1037: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1038: from pay_magnetic_blocks MGB,
1039: pay_report_format_mappings_f RFM
1040: where MGB.report_format = RFM.report_format
1041: AND RFM.report_format = L_REPORT_FORMAT
1042: AND RFM.report_category = 'RT');
1043: --
1043: --
1044: delete from pay_magnetic_blocks MGB
1045: where MGB.report_format in (
1046: SELECT report_format
1047: FROM pay_report_format_mappings_f
1048: WHERE report_format = L_REPORT_FORMAT
1049: AND report_category = 'RT');
1050: --
1051: delete from pay_report_format_mappings_f RFM
1047: FROM pay_report_format_mappings_f
1048: WHERE report_format = L_REPORT_FORMAT
1049: AND report_category = 'RT');
1050: --
1051: delete from pay_report_format_mappings_f RFM
1052: where RFM.report_format = L_REPORT_FORMAT
1053: and RFM.report_category = 'RT';
1054: --
1055: -- Report to format definitions.
1053: and RFM.report_category = 'RT';
1054: --
1055: -- Report to format definitions.
1056: --
1057: insert into pay_report_format_mappings_f
1058: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1059: RANGE_CODE,
1060: ASSIGNMENT_ACTION_CODE,
1061: INITIALIZATION_CODE,
1247: --
1248: delete from pay_magnetic_records MGR
1249: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1250: from pay_magnetic_blocks MGB,
1251: pay_report_format_mappings_f RFM
1252: where MGB.report_format = RFM.report_format
1253: AND RFM.report_format = L_REPORT_FORMAT
1254: AND RFM.report_category = 'RT');
1255: --
1255: --
1256: delete from pay_magnetic_blocks MGB
1257: where MGB.report_format in (
1258: SELECT report_format
1259: FROM pay_report_format_mappings_f
1260: WHERE report_format = L_REPORT_FORMAT
1261: AND report_category = 'RT');
1262: --
1263: delete from pay_report_format_mappings_f RFM
1259: FROM pay_report_format_mappings_f
1260: WHERE report_format = L_REPORT_FORMAT
1261: AND report_category = 'RT');
1262: --
1263: delete from pay_report_format_mappings_f RFM
1264: where RFM.report_format = L_REPORT_FORMAT
1265: and RFM.report_category = 'RT';
1266: --
1267: -- Report to format definitions.
1265: and RFM.report_category = 'RT';
1266: --
1267: -- Report to format definitions.
1268: --
1269: insert into pay_report_format_mappings_f
1270: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1271: RANGE_CODE,
1272: ASSIGNMENT_ACTION_CODE,
1273: INITIALIZATION_CODE,
1426: --
1427: delete from pay_magnetic_records MGR
1428: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1429: from pay_magnetic_blocks MGB,
1430: pay_report_format_mappings_f RFM
1431: where MGB.report_format = RFM.report_format
1432: AND RFM.report_format = L_REPORT_FORMAT
1433: AND RFM.report_category = 'RT');
1434: --
1434: --
1435: delete from pay_magnetic_blocks MGB
1436: where MGB.report_format in (
1437: SELECT report_format
1438: FROM pay_report_format_mappings_f
1439: WHERE report_format = L_REPORT_FORMAT
1440: AND report_category = 'RT');
1441: --
1442: delete from pay_report_format_mappings_f RFM
1438: FROM pay_report_format_mappings_f
1439: WHERE report_format = L_REPORT_FORMAT
1440: AND report_category = 'RT');
1441: --
1442: delete from pay_report_format_mappings_f RFM
1443: where RFM.report_format = L_REPORT_FORMAT
1444: and RFM.report_category = 'RT';
1445: --
1446: -- Report to format definitions.
1444: and RFM.report_category = 'RT';
1445: --
1446: -- Report to format definitions.
1447: --
1448: insert into pay_report_format_mappings_f
1449: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1450: RANGE_CODE,
1451: ASSIGNMENT_ACTION_CODE,
1452: INITIALIZATION_CODE,
1460: NULL,
1461: NULL,
1462: 'pay_magtape_generic.new_formula',
1463: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
1464: insert into pay_report_format_mappings_f
1465: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1466: RANGE_CODE,
1467: ASSIGNMENT_ACTION_CODE,
1468: INITIALIZATION_CODE,
1621: --
1622: delete from pay_magnetic_records MGR
1623: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1624: from pay_magnetic_blocks MGB,
1625: pay_report_format_mappings_f RFM
1626: where MGB.report_format = RFM.report_format
1627: AND RFM.report_format = L_REPORT_FORMAT
1628: AND RFM.report_category = 'RT');
1629: --
1629: --
1630: delete from pay_magnetic_blocks MGB
1631: where MGB.report_format in (
1632: SELECT report_format
1633: FROM pay_report_format_mappings_f
1634: WHERE report_format = L_REPORT_FORMAT
1635: AND report_category = 'RT');
1636: --
1637: --
1634: WHERE report_format = L_REPORT_FORMAT
1635: AND report_category = 'RT');
1636: --
1637: --
1638: delete from pay_report_format_mappings_f RFM
1639: where RFM.report_format = L_REPORT_FORMAT
1640: and RFM.report_category = 'RT';
1641: --
1642: -- Report to format definitions.
1640: and RFM.report_category = 'RT';
1641: --
1642: -- Report to format definitions.
1643: --
1644: insert into pay_report_format_mappings_f
1645: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1646: RANGE_CODE,
1647: ASSIGNMENT_ACTION_CODE,
1648: INITIALIZATION_CODE,
1800: --
1801: delete from pay_magnetic_records MGR
1802: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1803: from pay_magnetic_blocks MGB,
1804: pay_report_format_mappings_f RFM
1805: where MGB.report_format = RFM.report_format
1806: AND RFM.report_format = L_REPORT_FORMAT
1807: AND RFM.report_category = 'RT');
1808: --
1808: --
1809: delete from pay_magnetic_blocks MGB
1810: where MGB.report_format in (
1811: SELECT report_format
1812: FROM pay_report_format_mappings_f
1813: WHERE report_format = L_REPORT_FORMAT
1814: AND report_category = 'RT');
1815: --
1816: delete from pay_report_format_mappings_f RFM
1812: FROM pay_report_format_mappings_f
1813: WHERE report_format = L_REPORT_FORMAT
1814: AND report_category = 'RT');
1815: --
1816: delete from pay_report_format_mappings_f RFM
1817: where RFM.report_format = L_REPORT_FORMAT
1818: and RFM.report_category = 'RT';
1819: --
1820: -- Report to format definitions.
1818: and RFM.report_category = 'RT';
1819: --
1820: -- Report to format definitions.
1821: --
1822: insert into pay_report_format_mappings_f
1823: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1824: RANGE_CODE,
1825: ASSIGNMENT_ACTION_CODE,
1826: INITIALIZATION_CODE,
2012: --
2013: delete from pay_magnetic_records MGR
2014: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2015: from pay_magnetic_blocks MGB,
2016: pay_report_format_mappings_f RFM
2017: where MGB.report_format = RFM.report_format
2018: AND RFM.report_format = L_REPORT_FORMAT
2019: AND RFM.report_category = 'RT');
2020: --
2020: --
2021: delete from pay_magnetic_blocks MGB
2022: where MGB.report_format in (
2023: SELECT report_format
2024: FROM pay_report_format_mappings_f
2025: WHERE report_format = L_REPORT_FORMAT
2026: AND report_category = 'RT');
2027: --
2028: delete from pay_report_format_mappings_f RFM
2024: FROM pay_report_format_mappings_f
2025: WHERE report_format = L_REPORT_FORMAT
2026: AND report_category = 'RT');
2027: --
2028: delete from pay_report_format_mappings_f RFM
2029: where RFM.report_format = L_REPORT_FORMAT
2030: and RFM.report_category = 'RT';
2031: --
2032: -- Report to format definitions.
2030: and RFM.report_category = 'RT';
2031: --
2032: -- Report to format definitions.
2033: --
2034: insert into pay_report_format_mappings_f
2035: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2036: RANGE_CODE,
2037: ASSIGNMENT_ACTION_CODE,
2038: INITIALIZATION_CODE,
2236: --
2237: delete from pay_magnetic_records MGR
2238: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2239: from pay_magnetic_blocks MGB,
2240: pay_report_format_mappings_f RFM
2241: where MGB.report_format = RFM.report_format
2242: AND RFM.report_format = L_REPORT_FORMAT
2243: AND RFM.report_category = 'RT');
2244: --
2244: --
2245: delete from pay_magnetic_blocks MGB
2246: where MGB.report_format in (
2247: SELECT report_format
2248: FROM pay_report_format_mappings_f
2249: WHERE report_format = L_REPORT_FORMAT
2250: AND report_category = 'RT');
2251: --
2252: delete from pay_report_format_mappings_f RFM
2248: FROM pay_report_format_mappings_f
2249: WHERE report_format = L_REPORT_FORMAT
2250: AND report_category = 'RT');
2251: --
2252: delete from pay_report_format_mappings_f RFM
2253: where RFM.report_format = L_REPORT_FORMAT
2254: and RFM.report_category = 'RT';
2255: --
2256: -- Report to format definitions.
2254: and RFM.report_category = 'RT';
2255: --
2256: -- Report to format definitions.
2257: --
2258: insert into pay_report_format_mappings_f
2259: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2260: RANGE_CODE,
2261: ASSIGNMENT_ACTION_CODE,
2262: INITIALIZATION_CODE,
2427: --
2428: delete from pay_magnetic_records MGR
2429: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2430: from pay_magnetic_blocks MGB,
2431: pay_report_format_mappings_f RFM
2432: where MGB.report_format = RFM.report_format
2433: AND RFM.report_format = L_REPORT_FORMAT
2434: AND RFM.report_category = 'RT');
2435: --
2435: --
2436: delete from pay_magnetic_blocks MGB
2437: where MGB.report_format in (
2438: SELECT report_format
2439: FROM pay_report_format_mappings_f
2440: WHERE report_format = L_REPORT_FORMAT
2441: AND report_category = 'RT');
2442: --
2443: delete from pay_report_format_mappings_f RFM
2439: FROM pay_report_format_mappings_f
2440: WHERE report_format = L_REPORT_FORMAT
2441: AND report_category = 'RT');
2442: --
2443: delete from pay_report_format_mappings_f RFM
2444: where RFM.report_format = L_REPORT_FORMAT
2445: and RFM.report_category = 'RT';
2446: --
2447: -- Report to format definitions.
2445: and RFM.report_category = 'RT';
2446: --
2447: -- Report to format definitions.
2448: --
2449: insert into pay_report_format_mappings_f
2450: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2451: RANGE_CODE,
2452: ASSIGNMENT_ACTION_CODE,
2453: INITIALIZATION_CODE,
2632: --
2633: delete from pay_magnetic_records MGR
2634: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2635: from pay_magnetic_blocks MGB,
2636: pay_report_format_mappings_f RFM
2637: where MGB.report_format = RFM.report_format
2638: AND RFM.report_format = L_REPORT_FORMAT
2639: AND RFM.report_category = 'RT');
2640: --
2640: --
2641: delete from pay_magnetic_blocks MGB
2642: where MGB.report_format in (
2643: SELECT report_format
2644: FROM pay_report_format_mappings_f
2645: WHERE report_format = L_REPORT_FORMAT
2646: AND report_category = 'RT');
2647: --
2648: delete from pay_report_format_mappings_f RFM
2644: FROM pay_report_format_mappings_f
2645: WHERE report_format = L_REPORT_FORMAT
2646: AND report_category = 'RT');
2647: --
2648: delete from pay_report_format_mappings_f RFM
2649: where RFM.report_format = L_REPORT_FORMAT
2650: and RFM.report_category = 'RT';
2651: --
2652: -- Report to format definitions.
2650: and RFM.report_category = 'RT';
2651: --
2652: -- Report to format definitions.
2653: --
2654: insert into pay_report_format_mappings_f
2655: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2656: RANGE_CODE,
2657: ASSIGNMENT_ACTION_CODE,
2658: INITIALIZATION_CODE,