APPS.HR_US_FF_UDFS dependencies on PAY_US_COUNTIES

Line 3049: FROM PAY_US_COUNTIES

3045: -- State/County entered
3046:
3047: SELECT 'S'
3048: INTO v_valid_jurisdiction
3049: FROM PAY_US_COUNTIES
3050: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2)
3051: AND COUNTY_CODE = substr(p_jurisdiction_code, 4,3);
3052:
3053: END IF;

Line 4793: pay_us_counties b

4789: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4790: INTO l_geocode
4791: FROM pay_us_zip_codes z,
4792: pay_us_city_names a,
4793: pay_us_counties b
4794: WHERE a.city_name = l_query_city_name
4795: AND a.county_code = b.county_code
4796: AND UPPER(b.county_name) = UPPER(p_county_name) --Bug3783309-Changed Initcap to Upper.
4797: AND b.state_code = l_state_code

Line 4820: pay_us_counties b,

4816: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4817: INTO l_geocode
4818: FROM pay_us_zip_codes z,
4819: pay_us_city_names a,
4820: pay_us_counties b,
4821: pay_us_states c
4822: WHERE c.state_code = a.state_code AND
4823: c.state_abbrev = UPPER(p_state_abbrev)
4824: AND