APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 746: pay_us_city_tax_info_f citf

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
750: AND city.assignment_id = paa.assignment_id

Line 892: ,pay_us_city_tax_info_f citf

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
895: AND city.assignment_id = paa.assignment_id
896: AND names.city_code = substr(city.jurisdiction_code,8,4)

Line 1023: pay_us_city_tax_info_f citf

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
1027: AND names.city_code = substr(city.jurisdiction_code,8,4)

Line 1141: ,pay_us_city_tax_info_f citf

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
1144: AND city.assignment_id = paa.assignment_id
1145: AND names.city_code = substr(city.jurisdiction_code,8,4)