1748: run_val,
1749: tax_type_code,
1750: jurisdiction_code,
1751: ytd_val
1752: from pay_us_state_taxes_rbr_v
1753: where ee_or_er_code = 'EE'
1754: and assignment_action_id = l_assignment_action_id
1755: order by user_reporting_name;
1756:
1760: select state_abbrev,
1761: user_reporting_name,
1762: sum(run_val),
1763: tax_type_code
1764: from pay_us_state_taxes_rbr_v pt
1765: where pt.ee_or_er_code = 'EE'
1766: and pt.assignment_action_id = cp_run_action_id
1767: group by user_reporting_name, state_abbrev,tax_type_code
1768: order by user_reporting_name;
1773: select sum(pt.ytd_val)
1774: ,user_reporting_name
1775: ,tax_type_code
1776: ,state_abbrev
1777: from pay_us_state_taxes_rbr_v pt
1778: where pt.ee_or_er_code = 'EE'
1779: and pt.assignment_action_id = cp_master_action_id
1780: group by user_reporting_name, state_abbrev,tax_type_code
1781: order by user_reporting_name;