APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 2176: ln_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;

2172: group by peft.business_group_id;
2173:
2174: ld_eff_start_date date;
2175: ld_eff_end_date date;
2176: ln_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
2177: ln_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;
2178: ln_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;
2179: ln_old_city_code pay_us_modified_geocodes.old_city_code%TYPE;
2180:

Line 2390: pay_us_emp_state_tax_rules_f pusf

2386: pus.state_name,
2387: pusf.effective_start_date,
2388: pusf.effective_end_date
2389: FROM pay_us_states pus,
2390: pay_us_emp_state_tax_rules_f pusf
2391: WHERE pusf.assignment_id = p_assign_id
2392: AND pusf.state_code = pus.state_abbrev
2393: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
2394: where pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'