[Home] [Help]
563: p_quarter_end_date DATE) IS
564: select distinct pest.state_code,pus.state_abbrev
565: from per_all_assignments_f paaf,
566: hr_soft_coding_keyflex hsck,
567: pay_us_emp_state_tax_rules_f pest,
568: pay_us_states pus
569: where paaf.person_id = p_person_id
570: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
571: and paaf.effective_end_date >= p_year_start_date
621:
622: select distinct pest.state_code,pus.state_abbrev
623: from per_all_assignments_f paaf,
624: hr_soft_coding_keyflex hsck,
625: pay_us_emp_state_tax_rules_f pest,
626: pay_us_states pus
627: where paaf.person_id = p_person_id
628: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
629: and paaf.effective_end_date >= p_year_start_date