APPS.HR_CA_FF_UDFS dependencies on PAY_US_COUNTIES

Line 2638: FROM PAY_US_COUNTIES

2634: -- State/County entered
2635:
2636: SELECT 'S'
2637: INTO v_valid_jurisdiction
2638: FROM PAY_US_COUNTIES
2639: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2)
2640: AND COUNTY_CODE = substr(p_jurisdiction_code, 4,3);
2641:
2642: END IF;

Line 4245: pay_us_counties b

4241: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4242: INTO l_geocode
4243: FROM pay_us_zip_codes z,
4244: pay_us_city_names a,
4245: pay_us_counties b
4246: WHERE a.city_name = INITCAP(p_city_name)
4247: AND a.county_code = b.county_code
4248: AND b.county_name = INITCAP(p_county_name)
4249: AND b.state_code = l_state_code

Line 4272: pay_us_counties b,

4268: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4269: INTO l_geocode
4270: FROM pay_us_zip_codes z,
4271: pay_us_city_names a,
4272: pay_us_counties b,
4273: pay_us_states c
4274: WHERE c.state_code = a.state_code AND
4275: c.state_abbrev = UPPER(p_state_abbrev)
4276: AND