APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_CITY_NAMES

Line 745: pay_us_city_names names ,

741: pay_assignment_actions paa ,
742: pay_payroll_actions ppa ,
743: pay_us_local_tax_types_v petv ,
744: pay_us_emp_city_tax_rules_f city ,
745: pay_us_city_names names ,
746: pay_us_city_tax_info_f citf
747: WHERE paa.payroll_action_id = ppa.payroll_action_id
748: AND ppa.effective_date between city.effective_start_date
749: AND city.effective_end_date

Line 890: ,pay_us_city_names names

886: , city.jurisdiction_code
887: FROM pay_assignment_actions paa
888: ,pay_payroll_actions ppa
889: ,pay_us_local_ee_wage_types_v petv
890: ,pay_us_city_names names
891: ,pay_us_emp_city_tax_rules_f city
892: ,pay_us_city_tax_info_f citf
893: WHERE paa.payroll_action_id = ppa.payroll_action_id
894: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date

Line 1022: pay_us_city_names names ,

1018: FROM pay_assignment_actions paa ,
1019: pay_payroll_actions ppa ,
1020: pay_us_local_tax_types_v petv ,
1021: pay_us_emp_city_tax_rules_f city ,
1022: pay_us_city_names names ,
1023: pay_us_city_tax_info_f citf
1024: WHERE paa.payroll_action_id = ppa.payroll_action_id
1025: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date
1026: AND city.assignment_id = paa.assignment_id

Line 1139: ,pay_us_city_names names

1135: , city.jurisdiction_code
1136: FROM pay_assignment_actions paa
1137: ,pay_payroll_actions ppa
1138: ,pay_us_local_ee_wage_types_v petv
1139: ,pay_us_city_names names
1140: ,pay_us_emp_city_tax_rules_f city
1141: ,pay_us_city_tax_info_f citf
1142: WHERE paa.payroll_action_id = ppa.payroll_action_id
1143: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date