APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 2148: from pay_us_emp_county_tax_rules_f pecot

2144: cursor c_county_rec (p_assignment_id in number,
2145: p_state_code in varchar2,
2146: p_county_code in varchar2) is
2147: select business_group_id
2148: from pay_us_emp_county_tax_rules_f pecot
2149: where pecot.assignment_id = p_assignment_id
2150: and pecot.state_code = p_state_code
2151: and pecot.county_code = p_county_code;
2152:

Line 2177: ln_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;

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:
2181: ln_business_group_id number;

Line 2221: p_location => 'PAY_US_EMP_COUNTY_TAX_RULES_F',

2217: p_person_id => p_person_id,
2218: p_assign_id => p_assign_id,
2219: p_old_juri_code => ln_state_code||'-'||ln_county_code,
2220: p_new_juri_code => p_new_juri_code,
2221: p_location => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2222: p_id => null);
2223:
2224: hr_utility.set_location('pay_us_geo_upd_pkg.insert_ele_entries',4);
2225: