1058: sum(medicare_ee_withheld),
1059: sum(medicare_er_taxable),
1060: sum(medicare_er_liability),
1061: sum(eic_advance)
1062: FROM pay_us_federal_action_info_v fed
1063: WHERE fed.action_number = cp_action_number
1064: /* and cp_action_number not in
1065: (select fed2.action_number
1066: from pay_us_federal_action_info_v fed2
1062: FROM pay_us_federal_action_info_v fed
1063: WHERE fed.action_number = cp_action_number
1064: /* and cp_action_number not in
1065: (select fed2.action_number
1066: from pay_us_federal_action_info_v fed2
1067: where (fed2.fit_gross = 0
1068: or fed2.fit_gross is null)
1069: and (fed2.fit_withheld = 0
1070: or fed2.fit_withheld is null)