[Home] [Help]
193: L_REPORT_FORMAT := 'TIB4';
194: --
195: -- Clear down current format definition and its mappings.
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
388: L_REPORT_FORMAT := 'ST_TIB4';
389: --
390: -- Clear down current format definition and its mappings.
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
1032: L_REPORT_FORMAT := 'NJ_TIB4';
1033: --
1034: -- Clear down current format definition and its mappings.
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
1244: L_REPORT_FORMAT := 'WV_TIB4';
1245: --
1246: -- Clear down current format definition and its mappings.
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
1423: L_REPORT_FORMAT := 'MI_TIB4';
1424: --
1425: -- Clear down current format definition and its mappings.
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
1618: L_REPORT_FORMAT := 'KY_TIB4';
1619: --
1620: -- Clear down current format definition and its mappings.
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
1797: L_REPORT_FORMAT := 'MS_TIB4';
1798: --
1799: -- Clear down current format definition and its mappings.
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
2009: L_REPORT_FORMAT := 'IN_TIB4';
2010: --
2011: -- Clear down current format definition and its mappings.
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
2233: L_REPORT_FORMAT := 'CT_TIB4';
2234: --
2235: -- Clear down current format definition and its mappings.
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
2424: L_REPORT_FORMAT := 'OH_TIB4';
2425: --
2426: -- Clear down current format definition and its mappings.
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
2629: L_REPORT_FORMAT := 'NC_TIB4';
2630: --
2631: -- Clear down current format definition and its mappings.
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