2063: -- cursors to compare the location provided with the location of
2064: -- the employee's assignment
2065: CURSOR csr_chk_state IS
2066: SELECT 'PASS'
2067: FROM PAY_US_EMP_STATE_TAX_RULES st,
2068: PAY_US_STATES pus
2069: WHERE st.assignment_id = p_assignment_id
2070: and st.state_code = pus.state_code
2071: and pus.state_abbrev = p_state_abbrev
2691: SELECT sta.sit_exempt,
2692: sta.sdi_exempt,
2693: NVL(sta.STA_INFORMATION5,'N'),
2694: sta.sui_exempt
2695: FROM pay_us_emp_state_tax_rules_f sta,
2696: PER_ASSIGNMENTS_F a,
2697: PER_BUSINESS_GROUPS bg,
2698: pay_us_states pus
2699: WHERE sta.assignment_id = a.assignment_id