APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 382: ,pay_us_emp_state_tax_rules_f pue

378: SELECT DISTINCT
379: NVL(ppa.date_earned,ppa.effective_date)effective_date,
380: jurisdiction_code
381: FROM pay_assignment_actions paa
382: ,pay_us_emp_state_tax_rules_f pue
383: ,pay_payroll_actions ppa
384: WHERE paa.assignment_action_id = p_asact_id
385: AND pue.assignment_id = paa.assignment_id
386: AND ppa.payroll_action_id = paa.payroll_action_id

Line 419: ,pay_us_emp_state_tax_rules_f pue

415: , jurisdiction_code
416: FROM pay_assignment_actions paa
417: ,pay_payroll_actions ppa
418: ,pay_us_state_tax_types_v pstt
419: ,pay_us_emp_state_tax_rules_f pue
420: WHERE paa.assignment_action_id = p_asact_id
421: AND pue.assignment_id = paa.assignment_id
422: AND ppa.payroll_action_id = paa.payroll_action_id
423: AND ppa.effective_date between pue.effective_start_date

Line 494: ,pay_us_emp_state_tax_rules_f pue

490: , jurisdiction_code
491: FROM pay_assignment_actions paa
492: ,pay_payroll_actions ppa
493: ,pay_us_state_liability_types_v pstt
494: ,pay_us_emp_state_tax_rules_f pue
495: WHERE paa.assignment_action_id = p_asact_id
496: AND pue.assignment_id = paa.assignment_id
497: AND ppa.payroll_action_id = paa.payroll_action_id
498: AND ppa.effective_date between pue.effective_start_date

Line 534: ,pay_us_emp_state_tax_rules_f pue

530: , jurisdiction_code
531: FROM pay_assignment_actions paa
532: ,pay_payroll_actions ppa
533: ,pay_us_state_er_wage_types_v pstt
534: ,pay_us_emp_state_tax_rules_f pue
535: WHERE pue.assignment_id = paa.assignment_id
536: AND ppa.payroll_action_id = paa.payroll_action_id
537: AND ppa.effective_date between pue.effective_start_date
538: AND pue.effective_end_date