APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_COUNTIES

Line 677: pay_us_counties names

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
680: AND cnty.assignment_id = paa.assignment_id
681: AND names.county_code = substr(cnty.jurisdiction_code,4,3)

Line 835: ,pay_us_counties names

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
838: AND cnty.assignment_id = paa.assignment_id
839: AND names.county_code = substr(cnty.jurisdiction_code,4,3)

Line 950: pay_us_counties names

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
953: AND cnty.assignment_id = paa.assignment_id
954: AND names.county_code = substr(cnty.jurisdiction_code,4,3)

Line 1079: ,pay_us_counties names

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
1082: AND cnty.assignment_id = paa.assignment_id
1083: AND names.county_code = substr(cnty.jurisdiction_code,4,3)