[Home] [Help]
2862: and length(puar.jurisdiction_code)=16;
2863:
2864: cursor c_get_city is
2865: select distinct pcty.jurisdiction_code pcty
2866: from pay_us_emp_city_tax_rules_f pcty,
2867: per_assignments_f paf1,
2868: per_assignments_f paf
2869: where paf.assignment_id = l_asgid
2870: and paf.effective_end_date >= l_period_start