DBA Data[Home] [Help]

APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 778: pay_us_emp_county_tax_rules_f cnty ,

774: cnty.jurisdiction_code jurisdiction_code
775: FROM
776: pay_assignment_actions paa ,
777: pay_payroll_actions ppa ,
778: pay_us_emp_county_tax_rules_f cnty ,
779: pay_us_county_tax_info_f ctif ,
780: pay_us_counties names
781: WHERE paa.payroll_action_id = ppa.payroll_action_id
782: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 936: ,pay_us_emp_county_tax_rules_f cnty

932: , cnty.jurisdiction_code
933: FROM pay_assignment_actions paa
934: ,pay_payroll_actions ppa
935: ,pay_us_local_ee_wage_types_v petv
936: ,pay_us_emp_county_tax_rules_f cnty
937: ,pay_us_county_tax_info_f ctif
938: ,pay_us_counties names
939: WHERE paa.payroll_action_id = ppa.payroll_action_id
940: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 1051: pay_us_emp_county_tax_rules_f cnty ,

1047: NVL(ppa.date_earned,ppa.effective_date)effective_date,
1048: cnty.jurisdiction_code jurisdiction_code
1049: FROM pay_assignment_actions paa ,
1050: pay_payroll_actions ppa ,
1051: pay_us_emp_county_tax_rules_f cnty ,
1052: pay_us_county_tax_info_f ctif ,
1053: pay_us_counties names
1054: WHERE paa.payroll_action_id = ppa.payroll_action_id
1055: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date

Line 1180: ,pay_us_emp_county_tax_rules_f cnty

1176: , cnty.jurisdiction_code
1177: FROM pay_assignment_actions paa
1178: ,pay_payroll_actions ppa
1179: ,pay_us_local_ee_wage_types_v petv
1180: ,pay_us_emp_county_tax_rules_f cnty
1181: ,pay_us_county_tax_info_f ctif
1182: ,pay_us_counties names
1183: WHERE paa.payroll_action_id = ppa.payroll_action_id
1184: AND ppa.effective_date between cnty.effective_start_date AND cnty.effective_end_date