DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_LOCAL_TAXES_RBR_V

Line 2229: FROM pay_us_local_taxes_rbr_v

2225: tax_type_code,
2226: user_reporting_name,
2227: run_val,
2228: ytd_val
2229: FROM pay_us_local_taxes_rbr_v
2230: WHERE ee_or_er_code = 'EE'
2231: AND assignment_action_id = l_assignment_action_id
2232: order by user_reporting_name;
2233:

Line 2242: from pay_us_local_taxes_rbr_v pt

2238: jurisdiction_code,
2239: tax_type_code,
2240: user_reporting_name,
2241: sum(run_val)
2242: from pay_us_local_taxes_rbr_v pt
2243: where pt.ee_or_er_code = 'EE'
2244: and pt.assignment_action_id = cp_run_action_id
2245: group by user_reporting_name, city_name,jurisdiction_code, tax_type_code
2246: order by user_reporting_name;

Line 2256: from pay_us_local_taxes_rbr_v pt

2252: sum(pt.ytd_val),
2253: jurisdiction_code,
2254: tax_type_code,
2255: user_reporting_name
2256: from pay_us_local_taxes_rbr_v pt
2257: where pt.ee_or_er_code = 'EE'
2258: and pt.assignment_action_id = cp_master_action_id
2259: group by user_reporting_name, city_name,jurisdiction_code, tax_type_code
2260: order by user_reporting_name;