eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W3C_RPT dependencies on PAY_US_RPT_TOTALS

Line 495: FROM pay_us_rpt_totals

491: to_number(nvl(attribute25,0)) local_withheld_old,
492: to_number(nvl(attribute26,0)) local_withheld_new,
493: nvl(attribute27,' ') incorrect_name,
494: nvl(attribute28,' ') incorrect_ssn
495: FROM pay_us_rpt_totals
496: WHERE session_id = to_number(c_seq_num)
497: AND attribute3 in ('FEDERAL','BOX 12','BOX 14','STATE','LOCAL')
498: order by attribute4,
499: attribute5,

Line 513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;

509:
510: TYPE text_table IS TABLE OF varchar2(2000)
511: INDEX BY BINARY_INTEGER;
512:
513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;
514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;

Line 514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;

510: TYPE text_table IS TABLE OF varchar2(2000)
511: INDEX BY BINARY_INTEGER;
512:
513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;
514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;

Line 515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;

511: INDEX BY BINARY_INTEGER;
512:
513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;
514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;

Line 516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;

512:
513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;
514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;

Line 517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;

513: l_tax_unit_id pay_us_rpt_totals.tax_unit_id%TYPE := 9999999;
514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;

Line 518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;

514: l_wages_old pay_us_rpt_totals.value1%TYPE := 0;
515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;

Line 519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;

515: l_wages_new pay_us_rpt_totals.value2%TYPE := 0;
516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;

Line 520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;

516: l_fit_old pay_us_rpt_totals.value3%TYPE := 0;
517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;

Line 521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;

517: l_fit_new pay_us_rpt_totals.value4%TYPE := 0;
518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;

Line 522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;

518: l_ss_wages_old pay_us_rpt_totals.value5%TYPE := 0;
519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;

Line 523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;

519: l_ss_wages_new pay_us_rpt_totals.value6%TYPE := 0;
520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;

Line 524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;

520: l_ss_withheld_old pay_us_rpt_totals.value7%TYPE := 0;
521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;

Line 525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;

521: l_ss_withheld_new pay_us_rpt_totals.value8%TYPE := 0;
522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;

Line 526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;

522: l_medi_wages_old pay_us_rpt_totals.value9%TYPE := 0;
523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;

Line 527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;

523: l_medi_wages_new pay_us_rpt_totals.value10%TYPE := 0;
524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;

Line 528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;

524: l_medi_withheld_old pay_us_rpt_totals.value11%TYPE := 0;
525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;

Line 529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;

525: l_medi_withheld_new pay_us_rpt_totals.value12%TYPE := 0;
526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;

Line 530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;

526: l_ss_tips_old pay_us_rpt_totals.value13%TYPE := 0;
527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;

Line 531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;

527: l_ss_tips_new pay_us_rpt_totals.value14%TYPE := 0;
528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;

Line 532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;

528: l_alloc_tips_old pay_us_rpt_totals.value15%TYPE := 0;
529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;

Line 533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;

529: l_alloc_tips_new pay_us_rpt_totals.value16%TYPE := 0;
530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;

Line 534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;

530: l_eic_old pay_us_rpt_totals.value17%TYPE := 0;
531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;

Line 535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;

531: l_eic_new pay_us_rpt_totals.value18%TYPE := 0;
532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';

Line 536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;

532: l_depcare_old pay_us_rpt_totals.value19%TYPE := 0;
533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';

Line 537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;

533: l_depcare_new pay_us_rpt_totals.value20%TYPE :=0 ;
534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';

Line 538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;

534: l_nonqual_old pay_us_rpt_totals.value21%TYPE :=0 ;
535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';

Line 539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';

535: l_nonqual_new pay_us_rpt_totals.value22%TYPE :=0 ;
536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';

Line 540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';

536: l_third_party_sick_old pay_us_rpt_totals.value23%TYPE := 0;
537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';

Line 541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';

537: l_third_party_sick_new pay_us_rpt_totals.value24%TYPE := 0;
538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';

Line 542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';

538: l_report_type pay_us_rpt_totals.attribute1%TYPE := ' ' ;
539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';

Line 543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';

539: l_tax_year pay_us_rpt_totals.attribute2%TYPE := ' ';
540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';

Line 544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';

540: l_record_type pay_us_rpt_totals.attribute3%TYPE := ' ';
541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';

Line 545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';

541: l_employee_name pay_us_rpt_totals.attribute4%TYPE := ' ';
542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';

Line 546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';

542: l_ssn pay_us_rpt_totals.attribute5%TYPE := ' ';
543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';

Line 547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';

543: l_employer_name pay_us_rpt_totals.attribute6%TYPE := ' ';
544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';

Line 548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';

544: l_federal_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';

Line 549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';

545: l_fed_ein pay_us_rpt_totals.attribute7%TYPE := ' ';
546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';

Line 550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';

546: l_box_12_code pay_us_rpt_totals.attribute9%TYPE := ' ';
547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';

Line 551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';

547: l_box_12_value_old pay_us_rpt_totals.attribute10%TYPE := ' ';
548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';

Line 552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';

548: l_box_12_value_new pay_us_rpt_totals.attribute11%TYPE := ' ';
549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';

Line 553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';

549: l_box_14_code pay_us_rpt_totals.attribute12%TYPE := ' ';
550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';

Line 554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';

550: l_box_14_value_old pay_us_rpt_totals.attribute13%TYPE := ' ';
551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';

Line 555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';

551: l_box_14_value_new pay_us_rpt_totals.attribute14%TYPE := ' ';
552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';

Line 556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';

552: l_state_abbrev pay_us_rpt_totals.attribute15%TYPE := ' ';
553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';

Line 557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';

553: l_state_id_number pay_us_rpt_totals.attribute16%TYPE := ' ';
554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';

Line 558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';

554: l_state_id_sring pay_us_rpt_totals.attribute16%TYPE := ' ';
555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';

Line 559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';

555: l_state_inco_id_number pay_us_rpt_totals.attribute17%TYPE := ' ';
556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';

Line 560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';

556: l_state_inco_id_string pay_us_rpt_totals.attribute17%TYPE := ' ';
557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';

Line 561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';

557: l_ss_wages_tips_old pay_us_rpt_totals.attribute18%TYPE := ' ';
558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';

Line 562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';

558: l_ss_wages_tips_new pay_us_rpt_totals.attribute19%TYPE := ' ';
559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';

Line 563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';

559: l_sit_old pay_us_rpt_totals.attribute20%TYPE := ' ';
560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';

Line 564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';

560: l_sit_new pay_us_rpt_totals.attribute21%TYPE := ' ';
561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN

Line 565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';

561: l_state_local_name pay_us_rpt_totals.attribute22%TYPE := ' ';
562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN
569:

Line 566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';

562: l_local_wages_old pay_us_rpt_totals.attribute23%TYPE := ' ';
563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN
569:
570: --hr_utility.trace_on(null, 'W3CAUDIT');

Line 567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';

563: l_local_wages_new pay_us_rpt_totals.attribute24%TYPE := ' ';
564: l_local_withheld_old pay_us_rpt_totals.attribute25%TYPE := ' ';
565: l_local_withheld_new pay_us_rpt_totals.attribute26%TYPE := ' ';
566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN
569:
570: --hr_utility.trace_on(null, 'W3CAUDIT');
571: hr_utility.trace ('Entered Main package');

Line 834: DELETE FROM pay_us_rpt_totals

830:
831:
832: hr_utility.trace ('out of loop = ');
833:
834: DELETE FROM pay_us_rpt_totals
835: WHERE session_id = p_seq_num ;
836:
837:
838: