1712: WHERE assignment_id = p_assignment_id
1713: and jurisdiction_code = x_jd
1714: UNION
1715: SELECT 'PASS'
1716: FROM PAY_US_EMP_COUNTY_TAX_RULES
1717: WHERE assignment_id = p_assignment_id
1718: and jurisdiction_code = x_jd
1719: ;
1720:
2159: CURSOR csr_county_exempt (cp_jurisdiction_code IN VARCHAR2)
2160: IS
2161: SELECT cnt.lit_exempt,
2162: cnt.sd_exempt
2163: FROM pay_us_emp_county_tax_rules_f cnt,
2164: PER_ASSIGNMENTS_F a,
2165: PER_BUSINESS_GROUPS bg,
2166: pay_us_states pus
2167: WHERE cnt.assignment_id = a.assignment_id