APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 641: pay_us_emp_city_tax_rules_f city ,

637: FROM
638: pay_assignment_actions paa ,
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

Line 788: ,pay_us_emp_city_tax_rules_f city

784: FROM pay_assignment_actions paa
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

Line 918: pay_us_emp_city_tax_rules_f city ,

914: , city.jurisdiction_code
915: FROM pay_assignment_actions paa ,
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

Line 1037: ,pay_us_emp_city_tax_rules_f city

1033: FROM pay_assignment_actions paa
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