APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 643: pay_us_city_tax_info_f citf

639: pay_payroll_actions ppa ,
640: pay_us_local_tax_types_v petv ,
641: pay_us_emp_city_tax_rules_f city ,
642: pay_us_city_names names ,
643: pay_us_city_tax_info_f citf
644: WHERE paa.payroll_action_id = ppa.payroll_action_id
645: AND ppa.effective_date between city.effective_start_date
646: AND city.effective_end_date
647: AND city.assignment_id = paa.assignment_id

Line 789: ,pay_us_city_tax_info_f citf

785: ,pay_payroll_actions ppa
786: ,pay_us_local_ee_wage_types_v petv
787: ,pay_us_city_names names
788: ,pay_us_emp_city_tax_rules_f city
789: ,pay_us_city_tax_info_f citf
790: WHERE paa.payroll_action_id = ppa.payroll_action_id
791: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date
792: AND city.assignment_id = paa.assignment_id
793: AND names.city_code = substr(city.jurisdiction_code,8,4)

Line 920: pay_us_city_tax_info_f citf

916: pay_payroll_actions ppa ,
917: pay_us_local_tax_types_v petv ,
918: pay_us_emp_city_tax_rules_f city ,
919: pay_us_city_names names ,
920: pay_us_city_tax_info_f citf
921: WHERE paa.payroll_action_id = ppa.payroll_action_id
922: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date
923: AND city.assignment_id = paa.assignment_id
924: AND names.city_code = substr(city.jurisdiction_code,8,4)

Line 1038: ,pay_us_city_tax_info_f citf

1034: ,pay_payroll_actions ppa
1035: ,pay_us_local_ee_wage_types_v petv
1036: ,pay_us_city_names names
1037: ,pay_us_emp_city_tax_rules_f city
1038: ,pay_us_city_tax_info_f citf
1039: WHERE paa.payroll_action_id = ppa.payroll_action_id
1040: AND ppa.effective_date between city.effective_start_date AND city.effective_end_date
1041: AND city.assignment_id = paa.assignment_id
1042: AND names.city_code = substr(city.jurisdiction_code,8,4)