DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_STATE_TAXES_RBR_V

Line 1752: from pay_us_state_taxes_rbr_v

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:

Line 1764: from pay_us_state_taxes_rbr_v pt

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;

Line 1777: from pay_us_state_taxes_rbr_v pt

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;