APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_LOCAL_EE_WAGE_TYPES_V

Line 889: ,pay_us_local_ee_wage_types_v petv

885: , balance_category_code
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

Line 935: ,pay_us_local_ee_wage_types_v petv

931: , balance_category_code
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

Line 995: FROM pay_us_local_ee_wage_types_v petv

991: , 6) ordercol2
992: , tax_type_code
993: , balance_category_code
994: , p_jurisdiction_code jurisdiction_code
995: FROM pay_us_local_ee_wage_types_v petv
996: WHERE petv.tax_type_code in ('SCHOOL')
997: AND p_eff_date between petv.effective_start_date AND petv.effective_end_date
998: AND petv.tax_type_code <> 'SCHOOL'
999: ORDER BY 2,3;

Line 1138: ,pay_us_local_ee_wage_types_v petv

1134: , balance_category_code
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

Line 1179: ,pay_us_local_ee_wage_types_v petv

1175: , balance_category_code
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

Line 1233: FROM pay_us_local_ee_wage_types_v petv

1229: , 6) ordercol2
1230: , tax_type_code
1231: , balance_category_code
1232: , p_jurisdiction_code jurisdiction_code
1233: FROM pay_us_local_ee_wage_types_v petv
1234: WHERE p_eff_date between petv.effective_start_date AND petv.effective_end_date
1235: AND petv.tax_type_code = 'SCHOOL'
1236: ORDER BY 2,3;
1237: ------- Local ee wages = school-----------