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_RECORDS

Line 125: delete from pay_magnetic_records MGR

121: L_REPORT_FORMAT := 'ICESA';
122: --
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: --

Line 691: delete from pay_magnetic_records MGR

687: L_REPORT_FORMAT := 'SSA_SQWL';
688: --
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: --

Line 979: delete from pay_magnetic_records MGR

975: L_REPORT_FORMAT := 'NDSQWL';
976: --
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:

Line 1120: delete from pay_magnetic_records MGR

1116: L_REPORT_FORMAT := 'AKSQWL';
1117: --
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: --

Line 1249: delete from pay_magnetic_records MGR

1245: L_REPORT_FORMAT := 'IDSQWL';
1246: --
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: --

Line 1377: delete from pay_magnetic_records MGR

1373: L_REPORT_FORMAT := 'DCSQWL';
1374: --
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: --

Line 1506: delete from pay_magnetic_records MGR

1502: L_REPORT_FORMAT := 'PRSQWL';
1503: --
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: --

Line 1635: delete from pay_magnetic_records MGR

1631: L_REPORT_FORMAT := 'INSQWL';
1632: --
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: --

Line 1765: delete from pay_magnetic_records MGR

1761: L_REPORT_FORMAT := 'NJSQWL';
1762: --
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: --

Line 1895: delete from pay_magnetic_records MGR

1891: L_REPORT_FORMAT := 'GASQWL';
1892: --
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: --

Line 2024: delete from pay_magnetic_records MGR

2020: L_REPORT_FORMAT := 'NMSQWL';
2021: --
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: --

Line 2153: delete from pay_magnetic_records MGR

2149: L_REPORT_FORMAT := 'NYSQWL';
2150: --
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: --

Line 2286: delete from pay_magnetic_records MGR

2282: L_REPORT_FORMAT := 'OHSQWL';
2283: --
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: --

Line 2418: delete from pay_magnetic_records MGR

2414: L_REPORT_FORMAT := 'IASQWL';
2415: --
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: --

Line 2582: delete from pay_magnetic_records MGR

2578: L_REPORT_FORMAT := 'FLSQWL';
2579: --
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

Line 2733: delete from pay_magnetic_records MGR

2729: L_REPORT_FORMAT := 'RISQWL';
2730: --
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: --

Line 2865: delete from pay_magnetic_records MGR

2861: L_REPORT_FORMAT := 'WYSQWL';
2862: --
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: --

Line 2993: delete from pay_magnetic_records MGR

2989: L_REPORT_FORMAT := 'MISQWL';
2990: --
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: --

Line 3120: delete from pay_magnetic_records MGR

3116: L_REPORT_FORMAT := 'HISQWL';
3117: --
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: --

Line 3250: delete from pay_magnetic_records MGR

3246: L_REPORT_FORMAT := 'WASQWL';
3247: --
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: --

Line 3378: delete from pay_magnetic_records MGR

3374: L_REPORT_FORMAT := 'CTSQWL';
3375: --
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: --

Line 3505: delete from pay_magnetic_records MGR

3501: L_REPORT_FORMAT := 'ICESA_S';
3502: --
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: --

Line 3632: delete from pay_magnetic_records MGR

3628: L_REPORT_FORMAT := 'SDSQWLD';
3629: --
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: --

Line 3762: delete from pay_magnetic_records MGR

3758: L_REPORT_FORMAT := 'MDSQWLD';
3759: --
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: --

Line 3888: delete from pay_magnetic_records MGR

3884: L_REPORT_FORMAT := 'ILSQWLD';
3885: --
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: --

Line 4041: delete from pay_magnetic_records MGR

4037: L_REPORT_FORMAT := 'LAQJPT';
4038: --
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: --

Line 4182: delete from pay_magnetic_records MGR

4178: L_REPORT_FORMAT := 'ORSQWLF';
4179: --
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: --

Line 4324: delete from pay_magnetic_records MGR

4320: L_REPORT_FORMAT := 'NDSQWLF';
4321: --
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:

Line 4465: delete from pay_magnetic_records MGR

4461: L_REPORT_FORMAT := 'ICESAD';
4462: --
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: --

Line 4671: delete from pay_magnetic_records MGR

4667: L_REPORT_FORMAT := 'ICESA_SD';
4668: --
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: --

Line 4798: delete from pay_magnetic_records MGR

4794: L_REPORT_FORMAT := 'WYSQWLD';
4795: --
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: --