APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 279: ,pay_us_emp_state_tax_rules_f pue

275: SELECT DISTINCT
276: NVL(ppa.date_earned,ppa.effective_date)effective_date,
277: jurisdiction_code
278: FROM pay_assignment_actions paa
279: ,pay_us_emp_state_tax_rules_f pue
280: ,pay_payroll_actions ppa
281: WHERE paa.assignment_action_id = p_asact_id
282: AND pue.assignment_id = paa.assignment_id
283: AND ppa.payroll_action_id = paa.payroll_action_id

Line 316: ,pay_us_emp_state_tax_rules_f pue

312: , jurisdiction_code
313: FROM pay_assignment_actions paa
314: ,pay_payroll_actions ppa
315: ,pay_us_state_tax_types_v pstt
316: ,pay_us_emp_state_tax_rules_f pue
317: WHERE paa.assignment_action_id = p_asact_id
318: AND pue.assignment_id = paa.assignment_id
319: AND ppa.payroll_action_id = paa.payroll_action_id
320: AND ppa.effective_date between pue.effective_start_date

Line 391: ,pay_us_emp_state_tax_rules_f pue

387: , jurisdiction_code
388: FROM pay_assignment_actions paa
389: ,pay_payroll_actions ppa
390: ,pay_us_state_liability_types_v pstt
391: ,pay_us_emp_state_tax_rules_f pue
392: WHERE paa.assignment_action_id = p_asact_id
393: AND pue.assignment_id = paa.assignment_id
394: AND ppa.payroll_action_id = paa.payroll_action_id
395: AND ppa.effective_date between pue.effective_start_date

Line 431: ,pay_us_emp_state_tax_rules_f pue

427: , jurisdiction_code
428: FROM pay_assignment_actions paa
429: ,pay_payroll_actions ppa
430: ,pay_us_state_er_wage_types_v pstt
431: ,pay_us_emp_state_tax_rules_f pue
432: WHERE pue.assignment_id = paa.assignment_id
433: AND ppa.payroll_action_id = paa.payroll_action_id
434: AND ppa.effective_date between pue.effective_start_date
435: AND pue.effective_end_date