APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_LOCAL_TAX_TYPES_V

Line 743: pay_us_local_tax_types_v petv ,

739: , city.jurisdiction_code
740: FROM
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

Line 816: pay_us_local_tax_types_v petv

812: , tax_type_code
813: , balance_category_code
814: , p_jurisdiction_code jurisdiction_code
815: FROM
816: pay_us_local_tax_types_v petv
817: WHERE petv.tax_type_code = 'COUNTY'
818: AND p_eff_date between petv.effective_start_date AND petv.effective_end_date
819: AND petv.tax_type_code <> 'SCHOOL'
820: ORDER BY 2,3;

Line 859: FROM pay_us_local_tax_types_v petv

855: , 6) ordercol2
856: , tax_type_code
857: , balance_category_code
858: , p_jurisdiction_code jurisdiction_code
859: FROM pay_us_local_tax_types_v petv
860: WHERE p_eff_date between petv.effective_start_date AND petv.effective_end_date
861: AND petv.tax_type_code <> 'SCHOOL'
862: ORDER BY 2,3;
863:

Line 1020: pay_us_local_tax_types_v petv ,

1016: , balance_category_code
1017: , city.jurisdiction_code
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

Line 1083: pay_us_local_tax_types_v petv

1079: , tax_type_code
1080: , balance_category_code
1081: , p_jurisdiction_code jurisdiction_code
1082: FROM
1083: pay_us_local_tax_types_v petv
1084: WHERE petv.tax_type_code = 'COUNTY'
1085: AND p_eff_date between petv.effective_start_date AND petv.effective_end_date
1086: AND petv.tax_type_code = 'SCHOOL'
1087: ORDER BY 2,3;

Line 1105: pay_us_local_tax_types_v petv ,

1101: , balance_category_code
1102: , jurisdiction_code
1103: FROM pay_assignment_actions paa ,
1104: pay_payroll_actions ppa ,
1105: pay_us_local_tax_types_v petv ,
1106: pay_us_asg_schools_v school
1107: WHERE paa.payroll_action_id = ppa.payroll_action_id
1108: AND school.assignment_id = paa.assignment_id
1109: AND school.tax_unit_id = paa.tax_unit_id