APPS.HR_CA_FF_UDFS dependencies on PAY_US_COUNTIES

Line 2675: FROM PAY_US_COUNTIES

2671: -- State/County entered
2672:
2673: SELECT 'S'
2674: INTO v_valid_jurisdiction
2675: FROM PAY_US_COUNTIES
2676: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2)
2677: AND COUNTY_CODE = substr(p_jurisdiction_code, 4,3);
2678:
2679: END IF;

Line 4282: pay_us_counties b

4278: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4279: INTO l_geocode
4280: FROM pay_us_zip_codes z,
4281: pay_us_city_names a,
4282: pay_us_counties b
4283: WHERE a.city_name = INITCAP(p_city_name)
4284: AND a.county_code = b.county_code
4285: AND b.county_name = INITCAP(p_county_name)
4286: AND b.state_code = l_state_code

Line 4309: pay_us_counties b,

4305: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4306: INTO l_geocode
4307: FROM pay_us_zip_codes z,
4308: pay_us_city_names a,
4309: pay_us_counties b,
4310: pay_us_states c
4311: WHERE c.state_code = a.state_code AND
4312: c.state_abbrev = UPPER(p_state_abbrev)
4313: AND