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_REPORT_FORMAT_MAPPINGS_F

Line 133: delete from pay_report_format_mappings_f RFM

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;
135: --
136: -- Report to format definitions.
137: --

Line 140: insert into pay_report_format_mappings_f

136: -- Report to format definitions.
137: --
138: -- 17-Jan-1995 The Current List of ICESA States
139:
140: insert into pay_report_format_mappings_f
141: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
142: RANGE_CODE,
143: ASSIGNMENT_ACTION_CODE,
144: INITIALIZATION_CODE,

Line 157: insert into pay_report_format_mappings_f

153: 'pay_us_archive.archive_data',
154: 'pay_magtape_generic.new_formula',
155: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
156:
157: insert into pay_report_format_mappings_f
158: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
159: RANGE_CODE,
160: ASSIGNMENT_ACTION_CODE,
161: INITIALIZATION_CODE,

Line 174: insert into pay_report_format_mappings_f

170: 'pay_us_archive.archive_data',
171: 'pay_magtape_generic.new_formula',
172: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
173:
174: insert into pay_report_format_mappings_f
175: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
176: RANGE_CODE,
177: ASSIGNMENT_ACTION_CODE,
178: INITIALIZATION_CODE,

Line 191: insert into pay_report_format_mappings_f

187: 'pay_us_archive.archive_data',
188: 'pay_magtape_generic.new_formula',
189: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
190:
191: insert into pay_report_format_mappings_f
192: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
193: RANGE_CODE,
194: ASSIGNMENT_ACTION_CODE,
195: INITIALIZATION_CODE,

Line 208: insert into pay_report_format_mappings_f

204: 'pay_us_archive.archive_data',
205: 'pay_magtape_generic.new_formula',
206: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
207:
208: insert into pay_report_format_mappings_f
209: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
210: RANGE_CODE,
211: ASSIGNMENT_ACTION_CODE,
212: INITIALIZATION_CODE,

Line 225: insert into pay_report_format_mappings_f

221: 'pay_us_archive.archive_data',
222: 'pay_magtape_generic.new_formula',
223: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
224:
225: insert into pay_report_format_mappings_f
226: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
227: RANGE_CODE,
228: ASSIGNMENT_ACTION_CODE,
229: INITIALIZATION_CODE,

Line 242: insert into pay_report_format_mappings_f

238: 'pay_us_archive.archive_data',
239: 'pay_magtape_generic.new_formula',
240: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
241:
242: insert into pay_report_format_mappings_f
243: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
244: RANGE_CODE,
245: ASSIGNMENT_ACTION_CODE,
246: INITIALIZATION_CODE,

Line 259: insert into pay_report_format_mappings_f

255: 'pay_us_archive.archive_data',
256: 'pay_magtape_generic.new_formula',
257: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
258:
259: insert into pay_report_format_mappings_f
260: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
261: RANGE_CODE,
262: ASSIGNMENT_ACTION_CODE,
263: INITIALIZATION_CODE,

Line 276: insert into pay_report_format_mappings_f

272: 'pay_us_archive.archive_data',
273: 'pay_magtape_generic.new_formula',
274: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
275:
276: insert into pay_report_format_mappings_f
277: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
278: RANGE_CODE,
279: ASSIGNMENT_ACTION_CODE,
280: INITIALIZATION_CODE,

Line 293: insert into pay_report_format_mappings_f

289: 'pay_us_archive.archive_data',
290: 'pay_magtape_generic.new_formula',
291: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
292:
293: insert into pay_report_format_mappings_f
294: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
295: RANGE_CODE,
296: ASSIGNMENT_ACTION_CODE,
297: INITIALIZATION_CODE,

Line 310: insert into pay_report_format_mappings_f

306: 'pay_us_archive.archive_data',
307: 'pay_magtape_generic.new_formula',
308: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
309:
310: insert into pay_report_format_mappings_f
311: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
312: RANGE_CODE,
313: ASSIGNMENT_ACTION_CODE,
314: INITIALIZATION_CODE,

Line 327: insert into pay_report_format_mappings_f

323: 'pay_us_archive.archive_data',
324: 'pay_magtape_generic.new_formula',
325: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
326:
327: insert into pay_report_format_mappings_f
328: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
329: RANGE_CODE,
330: ASSIGNMENT_ACTION_CODE,
331: INITIALIZATION_CODE,

Line 344: insert into pay_report_format_mappings_f

340: 'pay_us_archive.archive_data',
341: 'pay_magtape_generic.new_formula',
342: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
343:
344: insert into pay_report_format_mappings_f
345: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
346: RANGE_CODE,
347: ASSIGNMENT_ACTION_CODE,
348: INITIALIZATION_CODE,

Line 361: insert into pay_report_format_mappings_f

357: 'pay_us_archive.archive_data',
358: 'pay_magtape_generic.new_formula',
359: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
360:
361: insert into pay_report_format_mappings_f
362: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
363: RANGE_CODE,
364: ASSIGNMENT_ACTION_CODE,
365: INITIALIZATION_CODE,

Line 378: insert into pay_report_format_mappings_f

374: 'pay_us_archive.archive_data',
375: 'pay_magtape_generic.new_formula',
376: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
377:
378: insert into pay_report_format_mappings_f
379: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
380: RANGE_CODE,
381: ASSIGNMENT_ACTION_CODE,
382: INITIALIZATION_CODE,

Line 395: insert into pay_report_format_mappings_f

391: 'pay_us_archive.archive_data',
392: 'pay_magtape_generic.new_formula',
393: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
394:
395: insert into pay_report_format_mappings_f
396: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
397: RANGE_CODE,
398: ASSIGNMENT_ACTION_CODE,
399: INITIALIZATION_CODE,

Line 412: insert into pay_report_format_mappings_f

408: 'pay_us_archive.archive_data',
409: 'pay_magtape_generic.new_formula',
410: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
411:
412: insert into pay_report_format_mappings_f
413: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
414: RANGE_CODE,
415: ASSIGNMENT_ACTION_CODE,
416: INITIALIZATION_CODE,

Line 429: insert into pay_report_format_mappings_f

425: 'pay_us_archive.archive_data',
426: 'pay_magtape_generic.new_formula',
427: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
428:
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,

Line 446: insert into pay_report_format_mappings_f

442: 'pay_us_archive.archive_data',
443: 'pay_magtape_generic.new_formula',
444: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
445:
446: insert into pay_report_format_mappings_f
447: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
448: RANGE_CODE,
449: ASSIGNMENT_ACTION_CODE,
450: INITIALIZATION_CODE,

Line 463: insert into pay_report_format_mappings_f

459: 'pay_us_archive.archive_data',
460: 'pay_magtape_generic.new_formula',
461: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
462:
463: insert into pay_report_format_mappings_f
464: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
465: RANGE_CODE,
466: ASSIGNMENT_ACTION_CODE,
467: INITIALIZATION_CODE,

Line 480: insert into pay_report_format_mappings_f

476: 'pay_us_archive.archive_data',
477: 'pay_magtape_generic.new_formula',
478: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
479:
480: insert into pay_report_format_mappings_f
481: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
482: RANGE_CODE,
483: ASSIGNMENT_ACTION_CODE,
484: INITIALIZATION_CODE,

Line 497: insert into pay_report_format_mappings_f

493: 'pay_us_archive.archive_data',
494: 'pay_magtape_generic.new_formula',
495: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
496:
497: insert into pay_report_format_mappings_f
498: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
499: RANGE_CODE,
500: ASSIGNMENT_ACTION_CODE,
501: INITIALIZATION_CODE,

Line 514: insert into pay_report_format_mappings_f

510: 'pay_us_archive.archive_data',
511: 'pay_magtape_generic.new_formula',
512: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
513:
514: insert into pay_report_format_mappings_f
515: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
516: RANGE_CODE,
517: ASSIGNMENT_ACTION_CODE,
518: INITIALIZATION_CODE,

Line 531: insert into pay_report_format_mappings_f

527: 'pay_us_archive.archive_data',
528: 'pay_magtape_generic.new_formula',
529: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
530:
531: insert into pay_report_format_mappings_f
532: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
533: RANGE_CODE,
534: ASSIGNMENT_ACTION_CODE,
535: INITIALIZATION_CODE,

Line 548: insert into pay_report_format_mappings_f

544: 'pay_us_archive.archive_data',
545: 'pay_magtape_generic.new_formula',
546: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
547:
548: insert into pay_report_format_mappings_f
549: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
550: RANGE_CODE,
551: ASSIGNMENT_ACTION_CODE,
552: INITIALIZATION_CODE,

Line 699: delete from pay_report_format_mappings_f RFM

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;
701: --
702: -- Report to format definitions.
703: --

Line 707: insert into pay_report_format_mappings_f

703: --
704: -- 17-Jan-1996 The Current List of SSA_SQWL States
705:
706:
707: insert into pay_report_format_mappings_f
708: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
709: RANGE_CODE,
710: ASSIGNMENT_ACTION_CODE,
711: INITIALIZATION_CODE,

Line 724: insert into pay_report_format_mappings_f

720: 'pay_us_archive.archive_data',
721: 'pay_magtape_generic.new_formula',
722: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
723:
724: insert into pay_report_format_mappings_f
725: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
726: RANGE_CODE,
727: ASSIGNMENT_ACTION_CODE,
728: INITIALIZATION_CODE,

Line 741: insert into pay_report_format_mappings_f

737: 'pay_us_archive.archive_data',
738: 'pay_magtape_generic.new_formula',
739: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
740:
741: insert into pay_report_format_mappings_f
742: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
743: RANGE_CODE,
744: ASSIGNMENT_ACTION_CODE,
745: INITIALIZATION_CODE,

Line 758: insert into pay_report_format_mappings_f

754: 'pay_us_archive.archive_data',
755: 'pay_magtape_generic.new_formula',
756: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
757:
758: insert into pay_report_format_mappings_f
759: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
760: RANGE_CODE,
761: ASSIGNMENT_ACTION_CODE,
762: INITIALIZATION_CODE,

Line 775: insert into pay_report_format_mappings_f

771: 'pay_us_archive.archive_data',
772: 'pay_magtape_generic.new_formula',
773: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
774:
775: insert into pay_report_format_mappings_f
776: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
777: RANGE_CODE,
778: ASSIGNMENT_ACTION_CODE,
779: INITIALIZATION_CODE,

Line 792: insert into pay_report_format_mappings_f

788: 'pay_us_archive.archive_data',
789: 'pay_magtape_generic.new_formula',
790: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
791:
792: insert into pay_report_format_mappings_f
793: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
794: RANGE_CODE,
795: ASSIGNMENT_ACTION_CODE,
796: INITIALIZATION_CODE,

Line 810: insert into pay_report_format_mappings_f

806: 'pay_magtape_generic.new_formula',
807: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
808:
809:
810: insert into pay_report_format_mappings_f
811: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
812: RANGE_CODE,
813: ASSIGNMENT_ACTION_CODE,
814: INITIALIZATION_CODE,

Line 827: insert into pay_report_format_mappings_f

823: 'pay_us_archive.archive_data',
824: 'pay_magtape_generic.new_formula',
825: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
826:
827: insert into pay_report_format_mappings_f
828: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
829: RANGE_CODE,
830: ASSIGNMENT_ACTION_CODE,
831: INITIALIZATION_CODE,

Line 844: insert into pay_report_format_mappings_f

840: 'pay_us_archive.archive_data',
841: 'pay_magtape_generic.new_formula',
842: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
843:
844: insert into pay_report_format_mappings_f
845: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
846: RANGE_CODE,
847: ASSIGNMENT_ACTION_CODE,
848: INITIALIZATION_CODE,

Line 987: delete from pay_report_format_mappings_f RFM

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;
989: --
990: -- Report to format definitions.
991:

Line 992: insert into pay_report_format_mappings_f

988: where RFM.report_format = L_REPORT_FORMAT;
989: --
990: -- Report to format definitions.
991:
992: insert into pay_report_format_mappings_f
993: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
994: RANGE_CODE,
995: ASSIGNMENT_ACTION_CODE,
996: INITIALIZATION_CODE,

Line 1128: delete from pay_report_format_mappings_f RFM

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;
1130: --
1131: -- Report to format definitions.
1132:

Line 1133: insert into pay_report_format_mappings_f

1129: where RFM.report_format = L_REPORT_FORMAT;
1130: --
1131: -- Report to format definitions.
1132:
1133: insert into pay_report_format_mappings_f
1134: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1135: RANGE_CODE,
1136: ASSIGNMENT_ACTION_CODE,
1137: INITIALIZATION_CODE,

Line 1257: delete from pay_report_format_mappings_f RFM

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;
1259: --
1260: -- Report to format definitions.
1261:

Line 1262: insert into pay_report_format_mappings_f

1258: where RFM.report_format = L_REPORT_FORMAT;
1259: --
1260: -- Report to format definitions.
1261:
1262: insert into pay_report_format_mappings_f
1263: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1264: RANGE_CODE,
1265: ASSIGNMENT_ACTION_CODE,
1266: INITIALIZATION_CODE,

Line 1385: delete from pay_report_format_mappings_f RFM

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;
1387: --
1388: -- Report to format definitions.
1389:

Line 1390: insert into pay_report_format_mappings_f

1386: where RFM.report_format = L_REPORT_FORMAT;
1387: --
1388: -- Report to format definitions.
1389:
1390: insert into pay_report_format_mappings_f
1391: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1392: RANGE_CODE,
1393: ASSIGNMENT_ACTION_CODE,
1394: INITIALIZATION_CODE,

Line 1514: delete from pay_report_format_mappings_f RFM

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;
1516: --
1517: -- Report to format definitions.
1518:

Line 1519: insert into pay_report_format_mappings_f

1515: where RFM.report_format = L_REPORT_FORMAT;
1516: --
1517: -- Report to format definitions.
1518:
1519: insert into pay_report_format_mappings_f
1520: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1521: RANGE_CODE,
1522: ASSIGNMENT_ACTION_CODE,
1523: INITIALIZATION_CODE,

Line 1643: delete from pay_report_format_mappings_f RFM

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;
1645: --
1646: -- Report to format definitions.
1647: /*

Line 1648: insert into pay_report_format_mappings_f

1644: where RFM.report_format = L_REPORT_FORMAT;
1645: --
1646: -- Report to format definitions.
1647: /*
1648: insert into pay_report_format_mappings_f
1649: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1650: RANGE_CODE,
1651: ASSIGNMENT_ACTION_CODE,
1652: INITIALIZATION_CODE,

Line 1773: delete from pay_report_format_mappings_f RFM

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;
1775: --
1776: -- Report to format definitions.
1777:

Line 1778: insert into pay_report_format_mappings_f

1774: where RFM.report_format = L_REPORT_FORMAT;
1775: --
1776: -- Report to format definitions.
1777:
1778: insert into pay_report_format_mappings_f
1779: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1780: RANGE_CODE,
1781: ASSIGNMENT_ACTION_CODE,
1782: INITIALIZATION_CODE,

Line 1903: delete from pay_report_format_mappings_f RFM

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;
1905: --
1906: -- Report to format definitions.
1907:

Line 1908: insert into pay_report_format_mappings_f

1904: where RFM.report_format = L_REPORT_FORMAT;
1905: --
1906: -- Report to format definitions.
1907:
1908: insert into pay_report_format_mappings_f
1909: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
1910: RANGE_CODE,
1911: ASSIGNMENT_ACTION_CODE,
1912: INITIALIZATION_CODE,

Line 2032: delete from pay_report_format_mappings_f RFM

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;
2034: --
2035: -- Report to format definitions.
2036:

Line 2037: insert into pay_report_format_mappings_f

2033: where RFM.report_format = L_REPORT_FORMAT;
2034: --
2035: -- Report to format definitions.
2036:
2037: insert into pay_report_format_mappings_f
2038: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2039: RANGE_CODE,
2040: ASSIGNMENT_ACTION_CODE,
2041: INITIALIZATION_CODE,

Line 2161: delete from pay_report_format_mappings_f RFM

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;
2163: --
2164: -- Report to format definitions.
2165:

Line 2166: insert into pay_report_format_mappings_f

2162: where RFM.report_format = L_REPORT_FORMAT;
2163: --
2164: -- Report to format definitions.
2165:
2166: insert into pay_report_format_mappings_f
2167: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2168: RANGE_CODE,
2169: ASSIGNMENT_ACTION_CODE,
2170: INITIALIZATION_CODE,

Line 2294: delete from pay_report_format_mappings_f RFM

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;
2296: --
2297: -- Report to format definitions.
2298:

Line 2299: insert into pay_report_format_mappings_f

2295: where RFM.report_format = L_REPORT_FORMAT;
2296: --
2297: -- Report to format definitions.
2298:
2299: insert into pay_report_format_mappings_f
2300: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2301: RANGE_CODE,
2302: ASSIGNMENT_ACTION_CODE,
2303: INITIALIZATION_CODE,

Line 2426: delete from pay_report_format_mappings_f RFM

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;
2428: --
2429: -- Report to format definitions.
2430: --

Line 2431: insert into pay_report_format_mappings_f

2427: where RFM.report_format = L_REPORT_FORMAT;
2428: --
2429: -- Report to format definitions.
2430: --
2431: insert into pay_report_format_mappings_f
2432: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2433: RANGE_CODE,
2434: ASSIGNMENT_ACTION_CODE,
2435: INITIALIZATION_CODE,

Line 2589: delete from pay_report_format_mappings_f RFM

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;
2591: --
2592: -- Report to format definitions.
2593: --

Line 2594: insert into pay_report_format_mappings_f

2590: where RFM.report_format = L_REPORT_FORMAT;
2591: --
2592: -- Report to format definitions.
2593: --
2594: insert into pay_report_format_mappings_f
2595: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2596: RANGE_CODE,
2597: ASSIGNMENT_ACTION_CODE,
2598: INITIALIZATION_CODE,

Line 2741: delete from pay_report_format_mappings_f RFM

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;
2743: --
2744: -- Report to format definitions.
2745:

Line 2746: insert into pay_report_format_mappings_f

2742: where RFM.report_format = L_REPORT_FORMAT;
2743: --
2744: -- Report to format definitions.
2745:
2746: insert into pay_report_format_mappings_f
2747: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2748: RANGE_CODE,
2749: ASSIGNMENT_ACTION_CODE,
2750: INITIALIZATION_CODE,

Line 2873: delete from pay_report_format_mappings_f RFM

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;
2875: --
2876: -- Report to format definitions.
2877:

Line 2878: insert into pay_report_format_mappings_f

2874: where RFM.report_format = L_REPORT_FORMAT;
2875: --
2876: -- Report to format definitions.
2877:
2878: insert into pay_report_format_mappings_f
2879: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
2880: RANGE_CODE,
2881: ASSIGNMENT_ACTION_CODE,
2882: INITIALIZATION_CODE,

Line 3001: delete from pay_report_format_mappings_f RFM

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;
3003: --
3004: -- Report to format definitions.
3005:

Line 3006: insert into pay_report_format_mappings_f

3002: where RFM.report_format = L_REPORT_FORMAT;
3003: --
3004: -- Report to format definitions.
3005:
3006: insert into pay_report_format_mappings_f
3007: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3008: RANGE_CODE,
3009: ASSIGNMENT_ACTION_CODE,
3010: INITIALIZATION_CODE,

Line 3128: delete from pay_report_format_mappings_f RFM

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;
3130: --
3131: -- Report to format definitions.
3132:

Line 3133: insert into pay_report_format_mappings_f

3129: where RFM.report_format = L_REPORT_FORMAT;
3130: --
3131: -- Report to format definitions.
3132:
3133: insert into pay_report_format_mappings_f
3134: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3135: RANGE_CODE,
3136: ASSIGNMENT_ACTION_CODE,
3137: INITIALIZATION_CODE,

Line 3258: delete from pay_report_format_mappings_f RFM

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;
3260: --
3261: -- Report to format definitions.
3262:

Line 3263: insert into pay_report_format_mappings_f

3259: where RFM.report_format = L_REPORT_FORMAT;
3260: --
3261: -- Report to format definitions.
3262:
3263: insert into pay_report_format_mappings_f
3264: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3265: RANGE_CODE,
3266: ASSIGNMENT_ACTION_CODE,
3267: INITIALIZATION_CODE,

Line 3386: delete from pay_report_format_mappings_f RFM

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;
3388: --
3389: -- Report to format definitions.
3390:

Line 3391: insert into pay_report_format_mappings_f

3387: where RFM.report_format = L_REPORT_FORMAT;
3388: --
3389: -- Report to format definitions.
3390:
3391: insert into pay_report_format_mappings_f
3392: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3393: RANGE_CODE,
3394: ASSIGNMENT_ACTION_CODE,
3395: INITIALIZATION_CODE,

Line 3513: delete from pay_report_format_mappings_f RFM

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;
3515: --
3516: -- Report to format definitions.
3517:

Line 3518: insert into pay_report_format_mappings_f

3514: where RFM.report_format = L_REPORT_FORMAT;
3515: --
3516: -- Report to format definitions.
3517:
3518: insert into pay_report_format_mappings_f
3519: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3520: RANGE_CODE,
3521: ASSIGNMENT_ACTION_CODE,
3522: INITIALIZATION_CODE,

Line 3640: delete from pay_report_format_mappings_f RFM

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;
3642: --
3643: -- Report to format definitions.
3644: --

Line 3645: insert into pay_report_format_mappings_f

3641: where RFM.report_format = L_REPORT_FORMAT;
3642: --
3643: -- Report to format definitions.
3644: --
3645: insert into pay_report_format_mappings_f
3646: (REPORT_TYPE,
3647: REPORT_QUALIFIER,
3648: REPORT_CATEGORY,
3649: REPORT_FORMAT,

Line 3770: delete from pay_report_format_mappings_f RFM

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;
3772: --
3773: -- Report to format definitions.
3774:

Line 3775: insert into pay_report_format_mappings_f

3771: where RFM.report_format = L_REPORT_FORMAT;
3772: --
3773: -- Report to format definitions.
3774:
3775: insert into pay_report_format_mappings_f
3776: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3777: RANGE_CODE,
3778: ASSIGNMENT_ACTION_CODE,
3779: INITIALIZATION_CODE,

Line 3896: delete from pay_report_format_mappings_f RFM

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;
3898: --
3899: -- Report to format definitions.
3900: --

Line 3902: insert into pay_report_format_mappings_f

3898: --
3899: -- Report to format definitions.
3900: --
3901: --
3902: insert into pay_report_format_mappings_f
3903: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
3904: RANGE_CODE,
3905: ASSIGNMENT_ACTION_CODE,
3906: INITIALIZATION_CODE,

Line 4049: delete from pay_report_format_mappings_f RFM

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;
4051: --
4052: -- Report to format definitions.
4053: --

Line 4055: insert into pay_report_format_mappings_f

4051: --
4052: -- Report to format definitions.
4053: --
4054: --
4055: insert into pay_report_format_mappings_f
4056: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4057: RANGE_CODE,
4058: ASSIGNMENT_ACTION_CODE,
4059: INITIALIZATION_CODE,

Line 4190: delete from pay_report_format_mappings_f RFM

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;
4192: --
4193: -- Report to format definitions.
4194: --

Line 4196: insert into pay_report_format_mappings_f

4192: --
4193: -- Report to format definitions.
4194: --
4195: --
4196: insert into pay_report_format_mappings_f
4197: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4198: RANGE_CODE,
4199: ASSIGNMENT_ACTION_CODE,
4200: INITIALIZATION_CODE,

Line 4332: delete from pay_report_format_mappings_f RFM

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;
4334: --
4335: -- Report to format definitions.
4336:

Line 4337: insert into pay_report_format_mappings_f

4333: where RFM.report_format = L_REPORT_FORMAT;
4334: --
4335: -- Report to format definitions.
4336:
4337: insert into pay_report_format_mappings_f
4338: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4339: RANGE_CODE,
4340: ASSIGNMENT_ACTION_CODE,
4341: INITIALIZATION_CODE,

Line 4473: delete from pay_report_format_mappings_f RFM

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;
4475: --
4476: -- Report to format definitions.
4477: --

Line 4480: insert into pay_report_format_mappings_f

4476: -- Report to format definitions.
4477: --
4478: -- 01-MAR-1999 The Current List of ICESA Diskette States
4479:
4480: insert into pay_report_format_mappings_f
4481: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4482: RANGE_CODE,
4483: ASSIGNMENT_ACTION_CODE,
4484: INITIALIZATION_CODE,

Line 4497: insert into pay_report_format_mappings_f

4493: 'pay_us_archive.archive_data',
4494: 'pay_magtape_generic.new_formula',
4495: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
4496:
4497: insert into pay_report_format_mappings_f
4498: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4499: RANGE_CODE,
4500: ASSIGNMENT_ACTION_CODE,
4501: INITIALIZATION_CODE,

Line 4514: insert into pay_report_format_mappings_f

4510: 'pay_us_archive.archive_data',
4511: 'pay_magtape_generic.new_formula',
4512: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
4513:
4514: insert into pay_report_format_mappings_f
4515: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4516: RANGE_CODE,
4517: ASSIGNMENT_ACTION_CODE,
4518: INITIALIZATION_CODE,

Line 4531: insert into pay_report_format_mappings_f

4527: 'pay_us_archive.archive_data',
4528: 'pay_magtape_generic.new_formula',
4529: L_REPORT_FORMAT, START_OF_TIME, END_OF_TIME);
4530:
4531: insert into pay_report_format_mappings_f
4532: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4533: RANGE_CODE,
4534: ASSIGNMENT_ACTION_CODE,
4535: INITIALIZATION_CODE,

Line 4679: delete from pay_report_format_mappings_f RFM

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;
4681: --
4682: -- Report to format definitions.
4683:

Line 4684: insert into pay_report_format_mappings_f

4680: where RFM.report_format = L_REPORT_FORMAT;
4681: --
4682: -- Report to format definitions.
4683:
4684: insert into pay_report_format_mappings_f
4685: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4686: RANGE_CODE,
4687: ASSIGNMENT_ACTION_CODE,
4688: INITIALIZATION_CODE,

Line 4806: delete from pay_report_format_mappings_f RFM

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;
4808: --
4809: -- Report to format definitions.
4810:

Line 4811: insert into pay_report_format_mappings_f

4807: where RFM.report_format = L_REPORT_FORMAT;
4808: --
4809: -- Report to format definitions.
4810:
4811: insert into pay_report_format_mappings_f
4812: ( REPORT_TYPE, REPORT_QUALIFIER, REPORT_CATEGORY,
4813: RANGE_CODE,
4814: ASSIGNMENT_ACTION_CODE,
4815: INITIALIZATION_CODE,