2465: group by peft.business_group_id;
2466:
2467: ld_eff_start_date date;
2468: ld_eff_end_date date;
2469: ln_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2470: ln_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;
2471: ln_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;
2472: ln_old_city_code pay_us_modified_geocodes.old_city_code%TYPE;
2473:
2679: pus.state_name,
2680: pusf.effective_start_date,
2681: pusf.effective_end_date
2682: FROM pay_us_states pus,
2683: pay_us_emp_state_tax_rules_f pusf
2684: WHERE pusf.assignment_id = p_assign_id
2685: AND pusf.state_code = pus.state_abbrev
2686: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
2687: where pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'