APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 2441: from pay_us_emp_county_tax_rules_f pecot

2437: cursor c_county_rec (p_assignment_id in number,
2438: p_state_code in varchar2,
2439: p_county_code in varchar2) is
2440: select business_group_id
2441: from pay_us_emp_county_tax_rules_f pecot
2442: where pecot.assignment_id = p_assignment_id
2443: and pecot.state_code = p_state_code
2444: and pecot.county_code = p_county_code;
2445:

Line 2470: ln_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;

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

Line 2514: p_location => 'PAY_US_EMP_COUNTY_TAX_RULES_F',

2510: p_person_id => p_person_id,
2511: p_assign_id => p_assign_id,
2512: p_old_juri_code => ln_state_code||'-'||ln_county_code,
2513: p_new_juri_code => p_new_juri_code,
2514: p_location => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2515: p_id => null);
2516:
2517: hr_utility.set_location('pay_us_geo_upd_pkg.insert_ele_entries',4);
2518: