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 dependencies on PAY_MAGNETIC_BLOCKS

Line 127: from pay_magnetic_blocks MGB

123: -- Clear down current format definition and its mappings.
124: --
125: delete from pay_magnetic_records MGR
126: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
127: from pay_magnetic_blocks MGB
128: where MGB.report_format = L_REPORT_FORMAT);
129: --
130: delete from pay_magnetic_blocks MGB
131: where MGB.report_format = L_REPORT_FORMAT;

Line 130: delete from pay_magnetic_blocks MGB

126: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
127: from pay_magnetic_blocks MGB
128: where MGB.report_format = L_REPORT_FORMAT);
129: --
130: delete from pay_magnetic_blocks MGB
131: where MGB.report_format = L_REPORT_FORMAT;
132: --
133: delete from pay_report_format_mappings_f RFM
134: where RFM.report_format = L_REPORT_FORMAT;

Line 693: from pay_magnetic_blocks MGB

689: -- Clear down current format definition and its mappings.
690: --
691: delete from pay_magnetic_records MGR
692: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
693: from pay_magnetic_blocks MGB
694: where MGB.report_format = L_REPORT_FORMAT);
695: --
696: delete from pay_magnetic_blocks MGB
697: where MGB.report_format = L_REPORT_FORMAT;

Line 696: delete from pay_magnetic_blocks MGB

692: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
693: from pay_magnetic_blocks MGB
694: where MGB.report_format = L_REPORT_FORMAT);
695: --
696: delete from pay_magnetic_blocks MGB
697: where MGB.report_format = L_REPORT_FORMAT;
698: --
699: delete from pay_report_format_mappings_f RFM
700: where RFM.report_format = L_REPORT_FORMAT;

Line 981: from pay_magnetic_blocks MGB

977: -- Clear down current format definition and its mappings.
978: --
979: delete from pay_magnetic_records MGR
980: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
981: from pay_magnetic_blocks MGB
982: where MGB.report_format = L_REPORT_FORMAT);
983:
984: delete from pay_magnetic_blocks MGB
985: where MGB.report_format = L_REPORT_FORMAT;

Line 984: delete from pay_magnetic_blocks MGB

980: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
981: from pay_magnetic_blocks MGB
982: where MGB.report_format = L_REPORT_FORMAT);
983:
984: delete from pay_magnetic_blocks MGB
985: where MGB.report_format = L_REPORT_FORMAT;
986: --
987: delete from pay_report_format_mappings_f RFM
988: where RFM.report_format = L_REPORT_FORMAT;

Line 1122: from pay_magnetic_blocks MGB

1118: -- Clear down current format definition and its mappings.
1119: --
1120: delete from pay_magnetic_records MGR
1121: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1122: from pay_magnetic_blocks MGB
1123: where MGB.report_format = L_REPORT_FORMAT);
1124: --
1125: delete from pay_magnetic_blocks MGB
1126: where MGB.report_format = L_REPORT_FORMAT;

Line 1125: delete from pay_magnetic_blocks MGB

1121: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1122: from pay_magnetic_blocks MGB
1123: where MGB.report_format = L_REPORT_FORMAT);
1124: --
1125: delete from pay_magnetic_blocks MGB
1126: where MGB.report_format = L_REPORT_FORMAT;
1127: --
1128: delete from pay_report_format_mappings_f RFM
1129: where RFM.report_format = L_REPORT_FORMAT;

Line 1251: from pay_magnetic_blocks MGB

1247: -- Clear down current format definition and its mappings.
1248: --
1249: delete from pay_magnetic_records MGR
1250: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1251: from pay_magnetic_blocks MGB
1252: where MGB.report_format = L_REPORT_FORMAT);
1253: --
1254: delete from pay_magnetic_blocks MGB
1255: where MGB.report_format = L_REPORT_FORMAT;

Line 1254: delete from pay_magnetic_blocks MGB

1250: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1251: from pay_magnetic_blocks MGB
1252: where MGB.report_format = L_REPORT_FORMAT);
1253: --
1254: delete from pay_magnetic_blocks MGB
1255: where MGB.report_format = L_REPORT_FORMAT;
1256: --
1257: delete from pay_report_format_mappings_f RFM
1258: where RFM.report_format = L_REPORT_FORMAT;

Line 1379: from pay_magnetic_blocks MGB

1375: -- Clear down current format definition and its mappings.
1376: --
1377: delete from pay_magnetic_records MGR
1378: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1379: from pay_magnetic_blocks MGB
1380: where MGB.report_format = L_REPORT_FORMAT);
1381: --
1382: delete from pay_magnetic_blocks MGB
1383: where MGB.report_format = L_REPORT_FORMAT;

Line 1382: delete from pay_magnetic_blocks MGB

1378: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1379: from pay_magnetic_blocks MGB
1380: where MGB.report_format = L_REPORT_FORMAT);
1381: --
1382: delete from pay_magnetic_blocks MGB
1383: where MGB.report_format = L_REPORT_FORMAT;
1384: --
1385: delete from pay_report_format_mappings_f RFM
1386: where RFM.report_format = L_REPORT_FORMAT;

Line 1508: from pay_magnetic_blocks MGB

1504: -- Clear down current format definition and its mappings.
1505: --
1506: delete from pay_magnetic_records MGR
1507: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1508: from pay_magnetic_blocks MGB
1509: where MGB.report_format = L_REPORT_FORMAT);
1510: --
1511: delete from pay_magnetic_blocks MGB
1512: where MGB.report_format = L_REPORT_FORMAT;

Line 1511: delete from pay_magnetic_blocks MGB

1507: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1508: from pay_magnetic_blocks MGB
1509: where MGB.report_format = L_REPORT_FORMAT);
1510: --
1511: delete from pay_magnetic_blocks MGB
1512: where MGB.report_format = L_REPORT_FORMAT;
1513: --
1514: delete from pay_report_format_mappings_f RFM
1515: where RFM.report_format = L_REPORT_FORMAT;

Line 1637: from pay_magnetic_blocks MGB

1633: -- Clear down current format definition and its mappings.
1634: --
1635: delete from pay_magnetic_records MGR
1636: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1637: from pay_magnetic_blocks MGB
1638: where MGB.report_format = L_REPORT_FORMAT);
1639: --
1640: delete from pay_magnetic_blocks MGB
1641: where MGB.report_format = L_REPORT_FORMAT;

Line 1640: delete from pay_magnetic_blocks MGB

1636: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1637: from pay_magnetic_blocks MGB
1638: where MGB.report_format = L_REPORT_FORMAT);
1639: --
1640: delete from pay_magnetic_blocks MGB
1641: where MGB.report_format = L_REPORT_FORMAT;
1642: --
1643: delete from pay_report_format_mappings_f RFM
1644: where RFM.report_format = L_REPORT_FORMAT;

Line 1767: from pay_magnetic_blocks MGB

1763: -- Clear down current format definition and its mappings.
1764: --
1765: delete from pay_magnetic_records MGR
1766: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1767: from pay_magnetic_blocks MGB
1768: where MGB.report_format = L_REPORT_FORMAT);
1769: --
1770: delete from pay_magnetic_blocks MGB
1771: where MGB.report_format = L_REPORT_FORMAT;

Line 1770: delete from pay_magnetic_blocks MGB

1766: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1767: from pay_magnetic_blocks MGB
1768: where MGB.report_format = L_REPORT_FORMAT);
1769: --
1770: delete from pay_magnetic_blocks MGB
1771: where MGB.report_format = L_REPORT_FORMAT;
1772: --
1773: delete from pay_report_format_mappings_f RFM
1774: where RFM.report_format = L_REPORT_FORMAT;

Line 1897: from pay_magnetic_blocks MGB

1893: -- Clear down current format definition and its mappings.
1894: --
1895: delete from pay_magnetic_records MGR
1896: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1897: from pay_magnetic_blocks MGB
1898: where MGB.report_format = L_REPORT_FORMAT);
1899: --
1900: delete from pay_magnetic_blocks MGB
1901: where MGB.report_format = L_REPORT_FORMAT;

Line 1900: delete from pay_magnetic_blocks MGB

1896: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
1897: from pay_magnetic_blocks MGB
1898: where MGB.report_format = L_REPORT_FORMAT);
1899: --
1900: delete from pay_magnetic_blocks MGB
1901: where MGB.report_format = L_REPORT_FORMAT;
1902: --
1903: delete from pay_report_format_mappings_f RFM
1904: where RFM.report_format = L_REPORT_FORMAT;

Line 2026: from pay_magnetic_blocks MGB

2022: -- Clear down current format definition and its mappings.
2023: --
2024: delete from pay_magnetic_records MGR
2025: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2026: from pay_magnetic_blocks MGB
2027: where MGB.report_format = L_REPORT_FORMAT);
2028: --
2029: delete from pay_magnetic_blocks MGB
2030: where MGB.report_format = L_REPORT_FORMAT;

Line 2029: delete from pay_magnetic_blocks MGB

2025: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2026: from pay_magnetic_blocks MGB
2027: where MGB.report_format = L_REPORT_FORMAT);
2028: --
2029: delete from pay_magnetic_blocks MGB
2030: where MGB.report_format = L_REPORT_FORMAT;
2031: --
2032: delete from pay_report_format_mappings_f RFM
2033: where RFM.report_format = L_REPORT_FORMAT;

Line 2155: from pay_magnetic_blocks MGB

2151: -- Clear down current format definition and its mappings.
2152: --
2153: delete from pay_magnetic_records MGR
2154: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2155: from pay_magnetic_blocks MGB
2156: where MGB.report_format = L_REPORT_FORMAT);
2157: --
2158: delete from pay_magnetic_blocks MGB
2159: where MGB.report_format = L_REPORT_FORMAT;

Line 2158: delete from pay_magnetic_blocks MGB

2154: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2155: from pay_magnetic_blocks MGB
2156: where MGB.report_format = L_REPORT_FORMAT);
2157: --
2158: delete from pay_magnetic_blocks MGB
2159: where MGB.report_format = L_REPORT_FORMAT;
2160: --
2161: delete from pay_report_format_mappings_f RFM
2162: where RFM.report_format = L_REPORT_FORMAT;

Line 2288: from pay_magnetic_blocks MGB

2284: -- Clear down current format definition and its mappings.
2285: --
2286: delete from pay_magnetic_records MGR
2287: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2288: from pay_magnetic_blocks MGB
2289: where MGB.report_format = L_REPORT_FORMAT);
2290: --
2291: delete from pay_magnetic_blocks MGB
2292: where MGB.report_format = L_REPORT_FORMAT;

Line 2291: delete from pay_magnetic_blocks MGB

2287: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2288: from pay_magnetic_blocks MGB
2289: where MGB.report_format = L_REPORT_FORMAT);
2290: --
2291: delete from pay_magnetic_blocks MGB
2292: where MGB.report_format = L_REPORT_FORMAT;
2293: --
2294: delete from pay_report_format_mappings_f RFM
2295: where RFM.report_format = L_REPORT_FORMAT;

Line 2420: from pay_magnetic_blocks MGB

2416: -- Clear down current format definition and its mappings.
2417: --
2418: delete from pay_magnetic_records MGR
2419: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2420: from pay_magnetic_blocks MGB
2421: where MGB.report_format = L_REPORT_FORMAT);
2422: --
2423: delete from pay_magnetic_blocks MGB
2424: where MGB.report_format = L_REPORT_FORMAT;

Line 2423: delete from pay_magnetic_blocks MGB

2419: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2420: from pay_magnetic_blocks MGB
2421: where MGB.report_format = L_REPORT_FORMAT);
2422: --
2423: delete from pay_magnetic_blocks MGB
2424: where MGB.report_format = L_REPORT_FORMAT;
2425: --
2426: delete from pay_report_format_mappings_f RFM
2427: where RFM.report_format = L_REPORT_FORMAT;

Line 2584: from pay_magnetic_blocks MGB

2580: -- Clear down current format definition and its mappings.
2581: --
2582: delete from pay_magnetic_records MGR
2583: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2584: from pay_magnetic_blocks MGB
2585: where MGB.report_format = L_REPORT_FORMAT); --
2586: delete from pay_magnetic_blocks MGB
2587: where MGB.report_format = L_REPORT_FORMAT;
2588: --

Line 2586: delete from pay_magnetic_blocks MGB

2582: delete from pay_magnetic_records MGR
2583: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2584: from pay_magnetic_blocks MGB
2585: where MGB.report_format = L_REPORT_FORMAT); --
2586: delete from pay_magnetic_blocks MGB
2587: where MGB.report_format = L_REPORT_FORMAT;
2588: --
2589: delete from pay_report_format_mappings_f RFM
2590: where RFM.report_format = L_REPORT_FORMAT;

Line 2735: from pay_magnetic_blocks MGB

2731: -- Clear down current format definition and its mappings.
2732: --
2733: delete from pay_magnetic_records MGR
2734: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2735: from pay_magnetic_blocks MGB
2736: where MGB.report_format = L_REPORT_FORMAT);
2737: --
2738: delete from pay_magnetic_blocks MGB
2739: where MGB.report_format = L_REPORT_FORMAT;

Line 2738: delete from pay_magnetic_blocks MGB

2734: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2735: from pay_magnetic_blocks MGB
2736: where MGB.report_format = L_REPORT_FORMAT);
2737: --
2738: delete from pay_magnetic_blocks MGB
2739: where MGB.report_format = L_REPORT_FORMAT;
2740: --
2741: delete from pay_report_format_mappings_f RFM
2742: where RFM.report_format = L_REPORT_FORMAT;

Line 2867: from pay_magnetic_blocks MGB

2863: -- Clear down current format definition and its mappings.
2864: --
2865: delete from pay_magnetic_records MGR
2866: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2867: from pay_magnetic_blocks MGB
2868: where MGB.report_format = L_REPORT_FORMAT);
2869: --
2870: delete from pay_magnetic_blocks MGB
2871: where MGB.report_format = L_REPORT_FORMAT;

Line 2870: delete from pay_magnetic_blocks MGB

2866: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2867: from pay_magnetic_blocks MGB
2868: where MGB.report_format = L_REPORT_FORMAT);
2869: --
2870: delete from pay_magnetic_blocks MGB
2871: where MGB.report_format = L_REPORT_FORMAT;
2872: --
2873: delete from pay_report_format_mappings_f RFM
2874: where RFM.report_format = L_REPORT_FORMAT;

Line 2995: from pay_magnetic_blocks MGB

2991: -- Clear down current format definition and its mappings.
2992: --
2993: delete from pay_magnetic_records MGR
2994: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2995: from pay_magnetic_blocks MGB
2996: where MGB.report_format = L_REPORT_FORMAT);
2997: --
2998: delete from pay_magnetic_blocks MGB
2999: where MGB.report_format = L_REPORT_FORMAT;

Line 2998: delete from pay_magnetic_blocks MGB

2994: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
2995: from pay_magnetic_blocks MGB
2996: where MGB.report_format = L_REPORT_FORMAT);
2997: --
2998: delete from pay_magnetic_blocks MGB
2999: where MGB.report_format = L_REPORT_FORMAT;
3000: --
3001: delete from pay_report_format_mappings_f RFM
3002: where RFM.report_format = L_REPORT_FORMAT;

Line 3122: from pay_magnetic_blocks MGB

3118: -- Clear down current format definition and its mappings.
3119: --
3120: delete from pay_magnetic_records MGR
3121: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3122: from pay_magnetic_blocks MGB
3123: where MGB.report_format = L_REPORT_FORMAT);
3124: --
3125: delete from pay_magnetic_blocks MGB
3126: where MGB.report_format = L_REPORT_FORMAT;

Line 3125: delete from pay_magnetic_blocks MGB

3121: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3122: from pay_magnetic_blocks MGB
3123: where MGB.report_format = L_REPORT_FORMAT);
3124: --
3125: delete from pay_magnetic_blocks MGB
3126: where MGB.report_format = L_REPORT_FORMAT;
3127: --
3128: delete from pay_report_format_mappings_f RFM
3129: where RFM.report_format = L_REPORT_FORMAT;

Line 3252: from pay_magnetic_blocks MGB

3248: -- Clear down current format definition and its mappings.
3249: --
3250: delete from pay_magnetic_records MGR
3251: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3252: from pay_magnetic_blocks MGB
3253: where MGB.report_format = L_REPORT_FORMAT);
3254: --
3255: delete from pay_magnetic_blocks MGB
3256: where MGB.report_format = L_REPORT_FORMAT;

Line 3255: delete from pay_magnetic_blocks MGB

3251: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3252: from pay_magnetic_blocks MGB
3253: where MGB.report_format = L_REPORT_FORMAT);
3254: --
3255: delete from pay_magnetic_blocks MGB
3256: where MGB.report_format = L_REPORT_FORMAT;
3257: --
3258: delete from pay_report_format_mappings_f RFM
3259: where RFM.report_format = L_REPORT_FORMAT;

Line 3380: from pay_magnetic_blocks MGB

3376: -- Clear down current format definition and its mappings.
3377: --
3378: delete from pay_magnetic_records MGR
3379: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3380: from pay_magnetic_blocks MGB
3381: where MGB.report_format = L_REPORT_FORMAT);
3382: --
3383: delete from pay_magnetic_blocks MGB
3384: where MGB.report_format = L_REPORT_FORMAT;

Line 3383: delete from pay_magnetic_blocks MGB

3379: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3380: from pay_magnetic_blocks MGB
3381: where MGB.report_format = L_REPORT_FORMAT);
3382: --
3383: delete from pay_magnetic_blocks MGB
3384: where MGB.report_format = L_REPORT_FORMAT;
3385: --
3386: delete from pay_report_format_mappings_f RFM
3387: where RFM.report_format = L_REPORT_FORMAT;

Line 3507: from pay_magnetic_blocks MGB

3503: -- Clear down current format definition and its mappings.
3504: --
3505: delete from pay_magnetic_records MGR
3506: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3507: from pay_magnetic_blocks MGB
3508: where MGB.report_format = L_REPORT_FORMAT);
3509: --
3510: delete from pay_magnetic_blocks MGB
3511: where MGB.report_format = L_REPORT_FORMAT;

Line 3510: delete from pay_magnetic_blocks MGB

3506: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3507: from pay_magnetic_blocks MGB
3508: where MGB.report_format = L_REPORT_FORMAT);
3509: --
3510: delete from pay_magnetic_blocks MGB
3511: where MGB.report_format = L_REPORT_FORMAT;
3512: --
3513: delete from pay_report_format_mappings_f RFM
3514: where RFM.report_format = L_REPORT_FORMAT;

Line 3634: from pay_magnetic_blocks MGB

3630: -- Clear down current format definition and its mappings.
3631: --
3632: delete from pay_magnetic_records MGR
3633: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3634: from pay_magnetic_blocks MGB
3635: where MGB.report_format = L_REPORT_FORMAT);
3636: --
3637: delete from pay_magnetic_blocks MGB
3638: where MGB.report_format = L_REPORT_FORMAT;

Line 3637: delete from pay_magnetic_blocks MGB

3633: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3634: from pay_magnetic_blocks MGB
3635: where MGB.report_format = L_REPORT_FORMAT);
3636: --
3637: delete from pay_magnetic_blocks MGB
3638: where MGB.report_format = L_REPORT_FORMAT;
3639: --
3640: delete from pay_report_format_mappings_f RFM
3641: where RFM.report_format = L_REPORT_FORMAT;

Line 3764: from pay_magnetic_blocks MGB

3760: -- Clear down current format definition and its mappings.
3761: --
3762: delete from pay_magnetic_records MGR
3763: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3764: from pay_magnetic_blocks MGB
3765: where MGB.report_format = L_REPORT_FORMAT);
3766: --
3767: delete from pay_magnetic_blocks MGB
3768: where MGB.report_format = L_REPORT_FORMAT;

Line 3767: delete from pay_magnetic_blocks MGB

3763: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3764: from pay_magnetic_blocks MGB
3765: where MGB.report_format = L_REPORT_FORMAT);
3766: --
3767: delete from pay_magnetic_blocks MGB
3768: where MGB.report_format = L_REPORT_FORMAT;
3769: --
3770: delete from pay_report_format_mappings_f RFM
3771: where RFM.report_format = L_REPORT_FORMAT;

Line 3890: from pay_magnetic_blocks MGB

3886: -- Clear down current format definition and its mappings.
3887: --
3888: delete from pay_magnetic_records MGR
3889: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3890: from pay_magnetic_blocks MGB
3891: where MGB.report_format = L_REPORT_FORMAT);
3892: --
3893: delete from pay_magnetic_blocks MGB
3894: where MGB.report_format = L_REPORT_FORMAT;

Line 3893: delete from pay_magnetic_blocks MGB

3889: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
3890: from pay_magnetic_blocks MGB
3891: where MGB.report_format = L_REPORT_FORMAT);
3892: --
3893: delete from pay_magnetic_blocks MGB
3894: where MGB.report_format = L_REPORT_FORMAT;
3895: --
3896: delete from pay_report_format_mappings_f RFM
3897: where RFM.report_format = L_REPORT_FORMAT;

Line 4043: from pay_magnetic_blocks MGB

4039: -- Clear down current format definition and its mappings.
4040: --
4041: delete from pay_magnetic_records MGR
4042: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4043: from pay_magnetic_blocks MGB
4044: where MGB.report_format = L_REPORT_FORMAT);
4045: --
4046: delete from pay_magnetic_blocks MGB
4047: where MGB.report_format = L_REPORT_FORMAT;

Line 4046: delete from pay_magnetic_blocks MGB

4042: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4043: from pay_magnetic_blocks MGB
4044: where MGB.report_format = L_REPORT_FORMAT);
4045: --
4046: delete from pay_magnetic_blocks MGB
4047: where MGB.report_format = L_REPORT_FORMAT;
4048: --
4049: delete from pay_report_format_mappings_f RFM
4050: where RFM.report_format = L_REPORT_FORMAT;

Line 4184: from pay_magnetic_blocks MGB

4180: -- Clear down current format definition and its mappings.
4181: --
4182: delete from pay_magnetic_records MGR
4183: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4184: from pay_magnetic_blocks MGB
4185: where MGB.report_format = L_REPORT_FORMAT);
4186: --
4187: delete from pay_magnetic_blocks MGB
4188: where MGB.report_format = L_REPORT_FORMAT;

Line 4187: delete from pay_magnetic_blocks MGB

4183: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4184: from pay_magnetic_blocks MGB
4185: where MGB.report_format = L_REPORT_FORMAT);
4186: --
4187: delete from pay_magnetic_blocks MGB
4188: where MGB.report_format = L_REPORT_FORMAT;
4189: --
4190: delete from pay_report_format_mappings_f RFM
4191: where RFM.report_format = L_REPORT_FORMAT;

Line 4326: from pay_magnetic_blocks MGB

4322: -- Clear down current format definition and its mappings.
4323: --
4324: delete from pay_magnetic_records MGR
4325: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4326: from pay_magnetic_blocks MGB
4327: where MGB.report_format = L_REPORT_FORMAT);
4328:
4329: delete from pay_magnetic_blocks MGB
4330: where MGB.report_format = L_REPORT_FORMAT;

Line 4329: delete from pay_magnetic_blocks MGB

4325: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4326: from pay_magnetic_blocks MGB
4327: where MGB.report_format = L_REPORT_FORMAT);
4328:
4329: delete from pay_magnetic_blocks MGB
4330: where MGB.report_format = L_REPORT_FORMAT;
4331: --
4332: delete from pay_report_format_mappings_f RFM
4333: where RFM.report_format = L_REPORT_FORMAT;

Line 4467: from pay_magnetic_blocks MGB

4463: -- Clear down current format definition and its mappings.
4464: --
4465: delete from pay_magnetic_records MGR
4466: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4467: from pay_magnetic_blocks MGB
4468: where MGB.report_format = L_REPORT_FORMAT);
4469: --
4470: delete from pay_magnetic_blocks MGB
4471: where MGB.report_format = L_REPORT_FORMAT;

Line 4470: delete from pay_magnetic_blocks MGB

4466: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4467: from pay_magnetic_blocks MGB
4468: where MGB.report_format = L_REPORT_FORMAT);
4469: --
4470: delete from pay_magnetic_blocks MGB
4471: where MGB.report_format = L_REPORT_FORMAT;
4472: --
4473: delete from pay_report_format_mappings_f RFM
4474: where RFM.report_format = L_REPORT_FORMAT;

Line 4673: from pay_magnetic_blocks MGB

4669: -- Clear down current format definition and its mappings.
4670: --
4671: delete from pay_magnetic_records MGR
4672: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4673: from pay_magnetic_blocks MGB
4674: where MGB.report_format = L_REPORT_FORMAT);
4675: --
4676: delete from pay_magnetic_blocks MGB
4677: where MGB.report_format = L_REPORT_FORMAT;

Line 4676: delete from pay_magnetic_blocks MGB

4672: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4673: from pay_magnetic_blocks MGB
4674: where MGB.report_format = L_REPORT_FORMAT);
4675: --
4676: delete from pay_magnetic_blocks MGB
4677: where MGB.report_format = L_REPORT_FORMAT;
4678: --
4679: delete from pay_report_format_mappings_f RFM
4680: where RFM.report_format = L_REPORT_FORMAT;

Line 4800: from pay_magnetic_blocks MGB

4796: -- Clear down current format definition and its mappings.
4797: --
4798: delete from pay_magnetic_records MGR
4799: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4800: from pay_magnetic_blocks MGB
4801: where MGB.report_format = L_REPORT_FORMAT);
4802: --
4803: delete from pay_magnetic_blocks MGB
4804: where MGB.report_format = L_REPORT_FORMAT;

Line 4803: delete from pay_magnetic_blocks MGB

4799: where MGR.magnetic_block_id in (select MGB.magnetic_block_id
4800: from pay_magnetic_blocks MGB
4801: where MGB.report_format = L_REPORT_FORMAT);
4802: --
4803: delete from pay_magnetic_blocks MGB
4804: where MGB.report_format = L_REPORT_FORMAT;
4805: --
4806: delete from pay_report_format_mappings_f RFM
4807: where RFM.report_format = L_REPORT_FORMAT;