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

Line 199: from pay_magnetic_blocks MGB,

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
202: AND RFM.report_format = L_REPORT_FORMAT
203: AND RFM.report_category = 'RT');

Line 205: delete from pay_magnetic_blocks MGB

201: where MGB.report_format = RFM.report_format
202: AND RFM.report_format = L_REPORT_FORMAT
203: AND RFM.report_category = 'RT');
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

Line 394: from pay_magnetic_blocks MGB,

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
397: AND RFM.report_format = L_REPORT_FORMAT
398: AND RFM.report_category = 'RT');

Line 400: delete from pay_magnetic_blocks MGB

396: where MGB.report_format = RFM.report_format
397: AND RFM.report_format = L_REPORT_FORMAT
398: AND RFM.report_category = 'RT');
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

Line 1038: from pay_magnetic_blocks MGB,

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
1041: AND RFM.report_format = L_REPORT_FORMAT
1042: AND RFM.report_category = 'RT');

Line 1044: delete from pay_magnetic_blocks MGB

1040: where MGB.report_format = RFM.report_format
1041: AND RFM.report_format = L_REPORT_FORMAT
1042: AND RFM.report_category = 'RT');
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

Line 1250: from pay_magnetic_blocks MGB,

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
1253: AND RFM.report_format = L_REPORT_FORMAT
1254: AND RFM.report_category = 'RT');

Line 1256: delete from pay_magnetic_blocks MGB

1252: where MGB.report_format = RFM.report_format
1253: AND RFM.report_format = L_REPORT_FORMAT
1254: AND RFM.report_category = 'RT');
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

Line 1429: from pay_magnetic_blocks MGB,

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
1432: AND RFM.report_format = L_REPORT_FORMAT
1433: AND RFM.report_category = 'RT');

Line 1435: delete from pay_magnetic_blocks MGB

1431: where MGB.report_format = RFM.report_format
1432: AND RFM.report_format = L_REPORT_FORMAT
1433: AND RFM.report_category = 'RT');
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

Line 1624: from pay_magnetic_blocks MGB,

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
1627: AND RFM.report_format = L_REPORT_FORMAT
1628: AND RFM.report_category = 'RT');

Line 1630: delete from pay_magnetic_blocks MGB

1626: where MGB.report_format = RFM.report_format
1627: AND RFM.report_format = L_REPORT_FORMAT
1628: AND RFM.report_category = 'RT');
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

Line 1803: from pay_magnetic_blocks MGB,

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
1806: AND RFM.report_format = L_REPORT_FORMAT
1807: AND RFM.report_category = 'RT');

Line 1809: delete from pay_magnetic_blocks MGB

1805: where MGB.report_format = RFM.report_format
1806: AND RFM.report_format = L_REPORT_FORMAT
1807: AND RFM.report_category = 'RT');
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

Line 2015: from pay_magnetic_blocks MGB,

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
2018: AND RFM.report_format = L_REPORT_FORMAT
2019: AND RFM.report_category = 'RT');

Line 2021: delete from pay_magnetic_blocks MGB

2017: where MGB.report_format = RFM.report_format
2018: AND RFM.report_format = L_REPORT_FORMAT
2019: AND RFM.report_category = 'RT');
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

Line 2239: from pay_magnetic_blocks MGB,

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
2242: AND RFM.report_format = L_REPORT_FORMAT
2243: AND RFM.report_category = 'RT');

Line 2245: delete from pay_magnetic_blocks MGB

2241: where MGB.report_format = RFM.report_format
2242: AND RFM.report_format = L_REPORT_FORMAT
2243: AND RFM.report_category = 'RT');
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

Line 2430: from pay_magnetic_blocks MGB,

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
2433: AND RFM.report_format = L_REPORT_FORMAT
2434: AND RFM.report_category = 'RT');

Line 2436: delete from pay_magnetic_blocks MGB

2432: where MGB.report_format = RFM.report_format
2433: AND RFM.report_format = L_REPORT_FORMAT
2434: AND RFM.report_category = 'RT');
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

Line 2635: from pay_magnetic_blocks MGB,

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
2638: AND RFM.report_format = L_REPORT_FORMAT
2639: AND RFM.report_category = 'RT');

Line 2641: delete from pay_magnetic_blocks MGB

2637: where MGB.report_format = RFM.report_format
2638: AND RFM.report_format = L_REPORT_FORMAT
2639: AND RFM.report_category = 'RT');
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