3243: CURSOR c_get_filing_status(p_assignment_id in number) is
3244: select filing_status_code
3245: from pay_us_emp_state_tax_rules_f pestr,
3246: per_all_assignments_f paf,
3247: hr_locations hl,
3248: pay_us_states pus
3249: where pestr.assignment_id = p_assignment_id
3250: and pestr.assignment_id = paf.assignment_id
3251: and paf.location_id = hl.location_id