17: The purpose of this package is to format reacord to support the
18: generation of W-2c magnetic tape for US legilsative requirements.
19:
20: Notes
21: Refers By: Package pay_us_w2c_in_mmref2_format
22:
23: History
24: 10-JAN-07 sausingh 115.11 5358272 added parameter_record(24) and parameter_record(25)
25: for RCT and RCW records for bug number 5358272
24: 10-JAN-07 sausingh 115.11 5358272 added parameter_record(24) and parameter_record(25)
25: for RCT and RCW records for bug number 5358272
26: 06-JAN-04 rsethupa 115.11 4097321 To display the RCO record in a03 and a02,
27: the global variable
28: pay_us_w2c_in_mmref2_format.rco_csv_record
29: is assigned values - return_value_csv and
30: return_value_mf depending on whether RCO has
31: errored out or it is correct.
32:
346: ||rpad(substr(nvl(r_input_22,'0'),1,1),1)
347: ||rpad(substr(nvl(r_input_23,' '),1,6),6)
348: ||lpad(' ',701);
349: -- These Variables are initialized to derive the file total
350: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
351: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
352: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
347: ||rpad(substr(nvl(r_input_23,' '),1,6),6)
348: ||lpad(' ',701);
349: -- These Variables are initialized to derive the file total
350: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
351: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
352: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
355: --
348: ||lpad(' ',701);
349: -- These Variables are initialized to derive the file total
350: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
351: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
352: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
355: --
356: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
349: -- These Variables are initialized to derive the file total
350: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
351: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
352: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
355: --
356: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
357: hr_utility.trace('RCA Record of FLAT Type -----');
717:
718: FOR i IN 1..ln_no_of_rcw_wages
719: LOOP
720: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
721: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
722: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
723: END LOOP;
724:
725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
718: FOR i IN 1..ln_no_of_rcw_wages
719: LOOP
720: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
721: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
722: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
723: END LOOP;
724:
725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
726:
723: END LOOP;
724:
725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
726:
727: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
728: return_value := 'RCT'
729: ||lv_no_of_rcw_records
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
726:
727: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
728: return_value := 'RCT'
729: ||lv_no_of_rcw_records
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
727: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
728: return_value := 'RCT'
729: ||lv_no_of_rcw_records
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
728: return_value := 'RCT'
729: ||lv_no_of_rcw_records
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
729: ||lv_no_of_rcw_records
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
730: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
731: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
732: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
733: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
734: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
735: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
736: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
737: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
738: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
739: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
768: --||lpad(' ',60)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
770: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
771: ||lpad(' ',30)
772: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
773: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
783: ||lpad(' ',234);
776: --||lpad(' ',324)
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
783: ||lpad(' ',234);
784:
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
783: ||lpad(' ',234);
784:
785: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
780: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
783: ||lpad(' ',234);
784:
785: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);
786: p_error := l_exclude_from_output_chk;
859: ln_no_of_rco_wages := 8;
860: FOR i IN 1..ln_no_of_rco_wages
861: LOOP
862: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
863: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
864: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
865: END LOOP;
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
860: FOR i IN 1..ln_no_of_rco_wages
861: LOOP
862: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
863: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
864: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
865: END LOOP;
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
868: return_value := 'RCU'
863: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
864: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
865: END LOOP;
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
868: return_value := 'RCU'
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
868: return_value := 'RCU'
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
868: return_value := 'RCU'
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
868: return_value := 'RCU'
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
871: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
872: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
873: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
874: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
875: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
876: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
877: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
878: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
879: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
880: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
887: ||lpad(' ',774);
881: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
887: ||lpad(' ',774);
888:
889: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);
882: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
883: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
884: --||lpad(' ',804);
885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
887: ||lpad(' ',774);
888:
889: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);
890: p_error := l_exclude_from_output_chk;
929: p_sickpay_indicator_new IN varchar2,
930: p_orig_assignment_actid IN varchar2,
931: p_correct_assignment_actid IN varchar2,
932: p_employee_number IN varchar2,
933: rcw_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
934: p_format_type IN varchar2,
935: p_validate IN varchar2,
936: p_exclude_from_output OUT nocopy varchar2,
937: ret_str_len OUT nocopy varchar2,
1342: ||lpad(p_retire_plan_indicator_new,1)
1343: ||lpad(p_sickpay_indicator_old,1)
1344: ||lpad(p_sickpay_indicator_new,1)
1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1344: ||lpad(p_sickpay_indicator_new,1)
1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record
1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record
1353: --{
1378: ||','||' '
1379: ||','||rpad(substr(nvl(p_foreign_state,' '),1,23),23)
1380: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1381: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1382: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1379: ||','||rpad(substr(nvl(p_foreign_state,' '),1,23),23)
1380: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1381: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1382: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1380: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1381: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1382: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1381: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1382: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1382: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1383: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1384: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1385: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1386: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1387: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1388: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1389: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1390: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1391: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1392: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1393: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1394: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1395: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1396: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1397: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1398: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1399: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1400: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1401: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1402: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1403: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1404: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1405: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1406: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1418: --||','||lpad(' ',22)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1421: ||','||lpad(' ',44)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1432: ||','||lpad(' ',187)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1432: ||','||lpad(' ',187)
1433: ||','||lpad(p_statutory_emp_indicator_old,1)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1432: ||','||lpad(' ',187)
1433: ||','||lpad(p_statutory_emp_indicator_old,1)
1434: ||','||lpad(p_statutory_emp_indicator_new,1)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1432: ||','||lpad(' ',187)
1433: ||','||lpad(p_statutory_emp_indicator_old,1)
1434: ||','||lpad(p_statutory_emp_indicator_new,1)
1435: ||','||lpad(p_retire_plan_indicator_old,1)
1518: ||','||lpad(' ',16);
1519:
1520: end if; /* l_exclude_from_output_chk */
1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1519:
1520: end if; /* l_exclude_from_output_chk */
1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1527: -- Format Blank RCW record in MMREF-2 format
1520: end if; /* l_exclude_from_output_chk */
1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1527: -- Format Blank RCW record in MMREF-2 format
1528: -- This Blank record would be used when RCO record is moved to .a02 for error
1599: ||','||' '
1600: ||','||' '
1601: ||','||' '
1602: ||','||' ';
1603: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1604: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1605: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1606: --}
1607:
1600: ||','||' '
1601: ||','||' '
1602: ||','||' ';
1603: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1604: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1605: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1606: --}
1607:
1608: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1627: p_last_name_new IN varchar2,
1628: p_orig_assignment_actid IN varchar2,
1629: p_correct_assignment_actid IN varchar2,
1630: p_employee_number IN varchar2,
1631: rco_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
1632: p_format_type IN varchar2,
1633: p_validate IN varchar2,
1634: p_exclude_from_output OUT nocopy varchar2,
1635: ret_str_len OUT nocopy varchar2,
1801: ||rco_wage_rec(7).wage_new_value_formated
1802: ||rco_wage_rec(8).wage_old_value_formated
1803: ||rco_wage_rec(8).wage_new_value_formated
1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1803: ||rco_wage_rec(8).wage_new_value_formated
1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record
1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record
1812: --{
1820:
1821: return_value_csv := ',' ||
1822: 'RCO'
1823: ||','||lpad(' ',9)
1824: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1821: return_value_csv := ',' ||
1822: 'RCO'
1823: ||','||lpad(' ',9)
1824: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1822: 'RCO'
1823: ||','||lpad(' ',9)
1824: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1823: ||','||lpad(' ',9)
1824: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1824: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1825: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1826: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1827: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1828: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1829: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1830: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1831: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1832: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1840: ||lpad(' ',836);
1833: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1840: ||lpad(' ',836);
1841: --||lpad(' ',858);
1834: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1840: ||lpad(' ',836);
1841: --||lpad(' ',858);
1842: /* Bug 4097321 - Assign return_value_csv to global variable*/
1835: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1836: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1837: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1838: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1840: ||lpad(' ',836);
1841: --||lpad(' ',858);
1842: /* Bug 4097321 - Assign return_value_csv to global variable*/
1843: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv;
1839: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1840: ||lpad(' ',836);
1841: --||lpad(' ',858);
1842: /* Bug 4097321 - Assign return_value_csv to global variable*/
1843: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv;
1844: --}
1845: else
1846:
1847: return_value_mf := 'RCO'
1866:
1867: --||','||lpad(' ',858);
1868: /* Bug 4097321 - Assign return_value_mf to global variable
1869: This is needed to print RCO in a03 if it is correct */
1870: pay_us_w2c_in_mmref2_format.rco_csv_record := ',' || return_value_mf;
1871:
1872: end if;
1873:
1874: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1871:
1872: end if;
1873:
1874: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1875: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1876: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1877: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1878: --}
1879: -- Format Blank RCO record in MMREF-2 format
1872: end if;
1873:
1874: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1875: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1876: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1877: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1878: --}
1879: -- Format Blank RCO record in MMREF-2 format
1880: -- This Blank record would be used when RCO record is moved to .a02 for error
1898: ||','||' '
1899: ||','||' '
1900: ||','||' '
1901: ||','||' ';
1902: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1903: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1904: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1905: --}
1906:
1899: ||','||' '
1900: ||','||' '
1901: ||','||' ';
1902: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1903: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1904: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1905: --}
1906:
1907: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);