APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 675: pay_us_emp_county_tax_rules_f cnty ,

671: cnty.jurisdiction_code jurisdiction_code
672: FROM
673: pay_assignment_actions paa ,
674: pay_payroll_actions ppa ,
675: pay_us_emp_county_tax_rules_f cnty ,
676: pay_us_county_tax_info_f ctif ,
677: pay_us_counties names
678: WHERE paa.payroll_action_id = ppa.payroll_action_id
679: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 833: ,pay_us_emp_county_tax_rules_f cnty

829: , cnty.jurisdiction_code
830: FROM pay_assignment_actions paa
831: ,pay_payroll_actions ppa
832: ,pay_us_local_ee_wage_types_v petv
833: ,pay_us_emp_county_tax_rules_f cnty
834: ,pay_us_county_tax_info_f ctif
835: ,pay_us_counties names
836: WHERE paa.payroll_action_id = ppa.payroll_action_id
837: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 948: pay_us_emp_county_tax_rules_f cnty ,

944: NVL(ppa.date_earned,ppa.effective_date)effective_date,
945: cnty.jurisdiction_code jurisdiction_code
946: FROM pay_assignment_actions paa ,
947: pay_payroll_actions ppa ,
948: pay_us_emp_county_tax_rules_f cnty ,
949: pay_us_county_tax_info_f ctif ,
950: pay_us_counties names
951: WHERE paa.payroll_action_id = ppa.payroll_action_id
952: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 1077: ,pay_us_emp_county_tax_rules_f cnty

1073: , cnty.jurisdiction_code
1074: FROM pay_assignment_actions paa
1075: ,pay_payroll_actions ppa
1076: ,pay_us_local_ee_wage_types_v petv
1077: ,pay_us_emp_county_tax_rules_f cnty
1078: ,pay_us_county_tax_info_f ctif
1079: ,pay_us_counties names
1080: WHERE paa.payroll_action_id = ppa.payroll_action_id
1081: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date