3045:
3046: cursor c_get_city is
3047: select distinct pcty.jurisdiction_code pcty
3048: from pay_us_city_tax_info_f cti,
3049: pay_us_emp_city_tax_rules_f pcty,
3050: per_all_assignments_f paf1
3051: where paf1.person_id = l_person_id
3052: and paf1.effective_end_date >= l_year_start
3053: and paf1.effective_start_date <= l_year_end
3139: cursor c_get_cty_sd is
3140: select distinct pcty.state_code || '-'|| pcty.school_district_code,
3141: county_code,
3142: city_code
3143: from pay_us_emp_city_tax_rules_f pcty,
3144: per_all_assignments_f paf1
3145: where paf1.person_id = l_person_id
3146: and paf1.effective_end_date >= l_year_start
3147: and paf1.effective_start_date <= l_year_end