APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on PAY_US_W2C_IN_MMREF2_FORMAT

Line 21: Refers By: Package pay_us_w2c_in_mmref2_format

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: 19-Nov-12 skchalla 115.17 14799562 Modified format_W2C_RCA_record, format_W2C_RCW_record and format_W2C_RCT_record
25: 10-Jan-11 skchalla 115.16 13255427 Modified Format_w2c_rcw_record to report the required

Line 35: pay_us_w2c_in_mmref2_format.rco_csv_record

31: 10-JAN-07 sausingh 115.11 5358272 added parameter_record(24) and parameter_record(25)
32: for RCT and RCW records for bug number 5358272
33: 06-JAN-04 rsethupa 115.11 4097321 To display the RCO record in a03 and a02,
34: the global variable
35: pay_us_w2c_in_mmref2_format.rco_csv_record
36: is assigned values - return_value_csv and
37: return_value_mf depending on whether RCO has
38: errored out or it is correct.
39:

Line 360: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;

356: ||rpad(substr(nvl(r_input_22,'0'),1,1),1)
357: ||rpad(substr(nvl(r_input_23,' '),1,6),6)
358: ||lpad(' ',701);
359: -- These Variables are initialized to derive the file total
360: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
361: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:

Line 361: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;

357: ||rpad(substr(nvl(r_input_23,' '),1,6),6)
358: ||lpad(' ',701);
359: -- These Variables are initialized to derive the file total
360: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
361: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:
365: --

Line 362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;

358: ||lpad(' ',701);
359: -- These Variables are initialized to derive the file total
360: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
361: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:
365: --
366: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);

Line 363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;

359: -- These Variables are initialized to derive the file total
360: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf := 0;
361: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcf := 0;
362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:
365: --
366: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
367: hr_utility.trace('RCA Record of FLAT Type -----');

Line 731: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated

727:
728: FOR i IN 1..ln_no_of_rcw_wages
729: LOOP
730: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
731: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
732: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
733: END LOOP;
734:
735: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);

Line 732: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);

728: FOR i IN 1..ln_no_of_rcw_wages
729: LOOP
730: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
731: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
732: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
733: END LOOP;
734:
735: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
736:

Line 737: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);

733: END LOOP;
734:
735: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
736:
737: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
738: return_value := 'RCT'
739: ||lv_no_of_rcw_records
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated

Line 740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated

736:
737: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
738: return_value := 'RCT'
739: ||lv_no_of_rcw_records
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated

Line 741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated

737: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
738: return_value := 'RCT'
739: ||lv_no_of_rcw_records
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated

Line 742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated

738: return_value := 'RCT'
739: ||lv_no_of_rcw_records
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated

Line 743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated

739: ||lv_no_of_rcw_records
740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated

Line 744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated

740: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_old_formated
741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated

Line 745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated

741: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(1).rct_wage_new_formated
742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated

Line 746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated

742: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_old_formated
743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated

Line 747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated

743: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(2).rct_wage_new_formated
744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated

Line 748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated

744: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_old_formated
745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated

Line 749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated

745: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(3).rct_wage_new_formated
746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated

Line 750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated

746: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_old_formated
747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated

Line 751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated

747: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(4).rct_wage_new_formated
748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated

Line 752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated

748: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_old_formated
749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated

Line 753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated

749: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(5).rct_wage_new_formated
750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated

Line 754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated

750: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_old_formated
751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated

Line 755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated

751: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(6).rct_wage_new_formated
752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated

Line 756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated

752: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_old_formated
753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated

Line 757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated

753: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(7).rct_wage_new_formated
754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated

Line 758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated

754: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_old_formated
755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated

Line 759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated

755: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(8).rct_wage_new_formated
756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated

Line 760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated

756: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_old_formated
757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated

Line 761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated

757: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(9).rct_wage_new_formated
758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated

Line 762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated

758: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_old_formated
759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated

Line 763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated

759: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(10).rct_wage_new_formated
760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated

Line 764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated

760: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_old_formated
761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated

Line 765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated

761: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(11).rct_wage_new_formated
762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated

Line 766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated

762: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_old_formated
763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated

Line 767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated

763: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(12).rct_wage_new_formated
764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated

Line 768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated

764: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_old_formated
765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled

Line 769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated

765: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(13).rct_wage_new_formated
766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled

Line 770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated

766: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_old_formated
767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated

Line 771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated

767: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(14).rct_wage_new_formated
768: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_old_formated
769: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(15).rct_wage_new_formated
770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated

Line 774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated

770: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_old_formated
771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated

Line 775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated

771: --||pay_us_w2c_in_mmref2_format.ltr_rct_info(16).rct_wage_new_formated
772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated

Line 776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated

772: ||lpad(' ',15) --Bug 14799562, RCT 461-475 is blank filled
773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)

Line 777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated

773: ||lpad(' ',15) --Bug 14799562, RCT 476-490 is blank filled
774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated

Line 778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated

774: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_old_formated
775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated

Line 779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated

775: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(17).rct_wage_new_formated
776: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_old_formated
777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)

Line 781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated

777: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(21).rct_wage_new_formated
778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated

Line 782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated

778: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_old_formated
779: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(18).rct_wage_new_formated
780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated

Line 784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated

780: --||lpad(' ',60)
781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)

Line 785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated

781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated

Line 786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated

782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(22).rct_wage_new_formated
783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated

Line 787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated

783: ||lpad(' ',30)
784: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_old_formated
785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */

Line 789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated

785: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(19).rct_wage_new_formated
786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated

Line 790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated

786: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_old_formated
787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated

Line 791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */

787: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(20).rct_wage_new_formated
788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427

Line 792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated

788: --||lpad(' ',324)
789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427

Line 793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated

789: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_old_formated
790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427
797: ||lpad(' ',204); --Changed from 234 for 13255427

Line 794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated

790: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(23).rct_wage_new_formated
791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427
797: ||lpad(' ',204); --Changed from 234 for 13255427
798:

Line 795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427

791: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_old_formated /* 5358272 */
792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427
797: ||lpad(' ',204); --Changed from 234 for 13255427
798:
799: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);

Line 796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427

792: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(24).rct_wage_new_formated
793: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
794: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427
797: ||lpad(' ',204); --Changed from 234 for 13255427
798:
799: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);
800: p_error := l_exclude_from_output_chk;

Line 879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated

875: ln_no_of_rco_wages := 10;--13255427
876: FOR i IN 1..ln_no_of_rco_wages
877: LOOP
878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
881: END LOOP;
882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);

Line 880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);

876: FOR i IN 1..ln_no_of_rco_wages
877: LOOP
878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
881: END LOOP;
882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
884: return_value := 'RCU'

Line 883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);

879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
881: END LOOP;
882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
884: return_value := 'RCU'
885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated

Line 886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated

882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
884: return_value := 'RCU'
885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated

Line 887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated

883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
884: return_value := 'RCU'
885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated

Line 888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated

884: return_value := 'RCU'
885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated

Line 889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated

885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated

Line 890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated

886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated
887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated

Line 891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated

887: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_new_formated
888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated

Line 892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated

888: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_old_formated
889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated

Line 893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated

889: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(2).rcu_wage_new_formated
890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated

Line 894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated

890: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_old_formated
891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated

Line 895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated

891: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(3).rcu_wage_new_formated
892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated

Line 896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated

892: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_old_formated
893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);

Line 897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated

893: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(4).rcu_wage_new_formated
894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated

Line 898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated

894: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_old_formated
895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated

Line 899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated

895: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(5).rcu_wage_new_formated
896: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_old_formated
897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383

Line 901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated

897: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(6).rcu_wage_new_formated
898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427

Line 902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated

898: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_old_formated
899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427

Line 903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383

899: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(7).rcu_wage_new_formated
900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427
907: ||lpad(' ',714);--old value 744 for the Bug 13255427

Line 904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated

900: --||lpad(' ',804);
901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427
907: ||lpad(' ',714);--old value 744 for the Bug 13255427
908:

Line 905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427

901: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427
907: ||lpad(' ',714);--old value 744 for the Bug 13255427
908:
909: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);

Line 906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427

902: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
903: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_old_formated--9783383
904: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(9).rcu_wage_new_formated
905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427
907: ||lpad(' ',714);--old value 744 for the Bug 13255427
908:
909: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);
910: p_error := l_exclude_from_output_chk;

Line 953: rcw_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,

949: p_sickpay_indicator_new IN varchar2,
950: p_orig_assignment_actid IN varchar2,
951: p_correct_assignment_actid IN varchar2,
952: p_employee_number IN varchar2,
953: rcw_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
954: p_format_type IN varchar2,
955: p_validate IN varchar2,
956: p_exclude_from_output OUT nocopy varchar2,
957: ret_str_len OUT nocopy varchar2,

Line 1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;

1367: ||lpad(p_retire_plan_indicator_new,1)
1368: ||lpad(p_sickpay_indicator_old,1)
1369: ||lpad(p_sickpay_indicator_new,1)
1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);

Line 1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);

1369: ||lpad(p_sickpay_indicator_new,1)
1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record

Line 1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));

1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record
1378: --{

Line 1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)

1403: ||','||' '
1404: ||','||rpad(substr(nvl(p_foreign_state,' '),1,23),23)
1405: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1406: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)

Line 1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)

1404: ||','||rpad(substr(nvl(p_foreign_state,' '),1,23),23)
1405: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1406: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)

Line 1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)

1405: ||','||rpad(substr(nvl(p_foreign_postal_code,' '),1,15),15)
1406: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)

Line 1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)

1406: ||','||rpad(substr(nvl(p_country_code,' '),1,2),2)
1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)

Line 1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)

1407: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information1*100)
1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)

Line 1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)

1408: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information1*100)
1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)

Line 1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)

1409: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information2*100)
1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)

Line 1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)

1410: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information2*100)
1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)

Line 1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)

1411: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information3*100)
1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)

Line 1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)

1412: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information3*100)
1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)

Line 1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)

1413: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information4*100)
1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)

Line 1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)

1414: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information4*100)
1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)

Line 1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)

1415: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information5*100)
1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)

Line 1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)

1416: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information5*100)
1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)

Line 1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)

1417: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information6*100)
1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)

Line 1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)

1418: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information6*100)
1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)

Line 1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)

1419: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information7*100)
1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)

Line 1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)

1420: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information7*100)
1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)

Line 1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)

1421: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information8*100)
1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)

Line 1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)

1422: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information8*100)
1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)

Line 1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)

1423: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information9*100)
1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)

Line 1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)

1424: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information9*100)
1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)

Line 1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)

1425: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information10*100)
1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)

Line 1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)

1426: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information10*100)
1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)

Line 1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)

1427: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information11*100)
1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)

Line 1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)

1428: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information11*100)
1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)

Line 1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)

1429: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information12*100)
1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)

Line 1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)

1430: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information12*100)
1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)

Line 1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)

1431: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information13*100)
1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled

Line 1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)

1432: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information13*100)
1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled

Line 1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)

1433: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information14*100)
1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)

Line 1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)

1434: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information14*100)
1435: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information15*100)
1436: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information15*100)
1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)

Line 1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)

1437: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information16*100)
1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)

Line 1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)

1438: --||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information16*100)
1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)

Line 1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)

1439: ||','||lpad(' ',11) --Bug 14799562, RCW 574-584 is blank filled
1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)

Line 1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)

1440: ||','||lpad(' ',11) --Bug 14799562, RCW 585-595 is blank filled
1441: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information17*100)
1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.

Line 1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)

1442: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information17*100)
1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)

Line 1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)

1443: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information21*100)
1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)

Line 1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.

1444: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information21*100)
1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)

Line 1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.

1445: --||','||lpad(' ',22)
1446: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information18*100)
1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)

Line 1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)

1447: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information18*100)
1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)

Line 1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)

1448: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information22*100) --Added Nontaxble combat pay.
1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)

Line 1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)

1449: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information22*100) -- Its only added in .mf earlier.
1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)

Line 1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)

1450: ||','||lpad(' ',22)
1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)

Line 1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)

1451: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information19*100)
1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)

Line 1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)

1452: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information19*100)
1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)

Line 1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)

1453: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information20*100)
1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427

Line 1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)

1454: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information20*100)
1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427
1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427

Line 1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)

1455: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information23*100)
1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427
1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427
1463: ||','||lpad(' ',165) --13255427

Line 1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)

1456: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information23*100)
1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427
1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427
1463: ||','||lpad(' ',165) --13255427
1464: ||','||lpad(p_statutory_emp_indicator_old,1)

Line 1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427

1457: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information24*100)
1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427
1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427
1463: ||','||lpad(' ',165) --13255427
1464: ||','||lpad(p_statutory_emp_indicator_old,1)
1465: ||','||lpad(p_statutory_emp_indicator_new,1)

Line 1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427

1458: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information24*100)
1459: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25*100)
1460: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25*100)
1461: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information26*100) --13255427
1462: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information26*100) --13255427
1463: ||','||lpad(' ',165) --13255427
1464: ||','||lpad(p_statutory_emp_indicator_old,1)
1465: ||','||lpad(p_statutory_emp_indicator_new,1)
1466: ||','||lpad(p_retire_plan_indicator_old,1)

Line 1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;

1555: ||','||lpad(' ',16);
1556:
1557: end if; /* l_exclude_from_output_chk */
1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}

Line 1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);

1556:
1557: end if; /* l_exclude_from_output_chk */
1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}
1564: -- Format Blank RCW record in MMREF-2 format

Line 1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));

1557: end if; /* l_exclude_from_output_chk */
1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}
1564: -- Format Blank RCW record in MMREF-2 format
1565: -- This Blank record would be used when RCO record is moved to .a02 for error

Line 1642: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;

1638: ||','||' '
1639: ||','||' '
1640: ||','||' ' --Added two columns for the Bug 13255427
1641: ||','||' ';
1642: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1645: --}
1646:

Line 1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);

1639: ||','||' '
1640: ||','||' ' --Added two columns for the Bug 13255427
1641: ||','||' ';
1642: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1645: --}
1646:
1647: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

Line 1670: rco_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,

1666: p_last_name_new IN varchar2,
1667: p_orig_assignment_actid IN varchar2,
1668: p_correct_assignment_actid IN varchar2,
1669: p_employee_number IN varchar2,
1670: rco_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
1671: p_format_type IN varchar2,
1672: p_validate IN varchar2,
1673: p_exclude_from_output OUT nocopy varchar2,
1674: ret_str_len OUT nocopy varchar2,

Line 1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;

1847: -- ||lpad(' ',814); --previous value 836 9783383
1848: ||rco_wage_rec(10).wage_old_value_formated --13255427
1849: ||rco_wage_rec(10).wage_new_value_formated --13255427
1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);

Line 1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);

1849: ||rco_wage_rec(10).wage_new_value_formated --13255427
1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record

Line 1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));

1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record
1858: --{

Line 1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)

1866:
1867: return_value_csv := ',' ||
1868: 'RCO'
1869: ||','||lpad(' ',9)
1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)

Line 1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)

1867: return_value_csv := ',' ||
1868: 'RCO'
1869: ||','||lpad(' ',9)
1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)

Line 1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)

1868: 'RCO'
1869: ||','||lpad(' ',9)
1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)

Line 1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)

1869: ||','||lpad(' ',9)
1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)

Line 1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)

1870: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information1*100)
1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)

Line 1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)

1871: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information1*100)
1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)

Line 1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)

1872: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information2*100)
1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)

Line 1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)

1873: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information2*100)
1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)

Line 1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)

1874: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information3*100)
1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)

Line 1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)

1875: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information3*100)
1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)

Line 1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)

1876: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information4*100)
1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)

Line 1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)

1877: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information4*100)
1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)

Line 1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)

1878: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information5*100)
1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383

Line 1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)

1879: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information5*100)
1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383

Line 1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)

1880: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information6*100)
1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427

Line 1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)

1881: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information6*100)
1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427
1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427

Line 1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383

1882: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information7*100)
1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427
1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427
1890: ||lpad(' ',792);--||lpad(' ',814); 13255427

Line 1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383

1883: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information7*100)
1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427
1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427
1890: ||lpad(' ',792);--||lpad(' ',814); 13255427
1891: --||lpad(' ',858);

Line 1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427

1884: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8*100)
1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427
1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427
1890: ||lpad(' ',792);--||lpad(' ',814); 13255427
1891: --||lpad(' ',858);
1892: /* Bug 4097321 - Assign return_value_csv to global variable*/

Line 1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427

1885: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8*100)
1886: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information9*100) --9783383
1887: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information9*100) --9783383
1888: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information10*100) --13255427
1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427
1890: ||lpad(' ',792);--||lpad(' ',814); 13255427
1891: --||lpad(' ',858);
1892: /* Bug 4097321 - Assign return_value_csv to global variable*/
1893: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv;

Line 1893: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv;

1889: ||','||to_char(pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information10*100) --13255427
1890: ||lpad(' ',792);--||lpad(' ',814); 13255427
1891: --||lpad(' ',858);
1892: /* Bug 4097321 - Assign return_value_csv to global variable*/
1893: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv;
1894: --}
1895: else
1896:
1897: return_value_mf := 'RCO'

Line 1924: pay_us_w2c_in_mmref2_format.rco_csv_record := ',' || return_value_mf;

1920:
1921: --||','||lpad(' ',858);
1922: /* Bug 4097321 - Assign return_value_mf to global variable
1923: This is needed to print RCO in a03 if it is correct */
1924: pay_us_w2c_in_mmref2_format.rco_csv_record := ',' || return_value_mf;
1925:
1926: end if;
1927:
1928: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above

Line 1929: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */

1925:
1926: end if;
1927:
1928: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1929: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1931: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1932: --}
1933: -- Format Blank RCO record in MMREF-2 format

Line 1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);

1926: end if;
1927:
1928: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1929: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1931: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1932: --}
1933: -- Format Blank RCO record in MMREF-2 format
1934: -- This Blank record would be used when RCO record is moved to .a02 for error

Line 1961: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;

1957: ||','||' ' --Added 2 commas to meet the RCO record stucture --9783383
1958: ||','||' '
1959: ||','||' ' --Added 2 commas to meet the RCO record stucture --13255427
1960: ||','||' ';
1961: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1964: --}
1965:

Line 1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);

1958: ||','||' '
1959: ||','||' ' --Added 2 commas to meet the RCO record stucture --13255427
1960: ||','||' ';
1961: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1964: --}
1965:
1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);