299: --
300: -- Call create_asg_geo_row to create rows in the pay_us_asg_reporting
301: -- table if this is a new county
302: --
303: pay_asg_geo_pkg.create_asg_geo_row(
304: p_assignment_id => p_assignment_id
305: ,p_jurisdiction => l_jurisdiction_code
306: );
307: End if;
668: p_effective_date);
669: FETCH csr_assignment_id
670: INTO l_assignment_id,
671: l_jurisdiction_code;
672: pay_asg_geo_pkg.create_asg_geo_row(
673: p_assignment_id => l_assignment_id
674: ,p_jurisdiction => l_jurisdiction_code
675: );
676: CLOSE csr_assignment_id;