APPS.HR_US_FF_UDFS dependencies on PAY_US_STATES

Line 3045: -- Only entered a state geo, check against PAY_US_STATES.

3041: IF substr(p_jurisdiction_code, 8,4) = '0000' THEN
3042:
3043: IF substr(p_jurisdiction_code, 4,3) = '000' THEN
3044:
3045: -- Only entered a state geo, check against PAY_US_STATES.
3046:
3047: SELECT 'S'
3048: INTO v_valid_jurisdiction
3049: FROM PAY_US_STATES

Line 3049: FROM PAY_US_STATES

3045: -- Only entered a state geo, check against PAY_US_STATES.
3046:
3047: SELECT 'S'
3048: INTO v_valid_jurisdiction
3049: FROM PAY_US_STATES
3050: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2);
3051:
3052: ELSE
3053:

Line 4850: FROM pay_us_states

4846: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo
4847: -- same county name can exists in many states
4848: SELECT state_code
4849: INTO l_state_code
4850: FROM pay_us_states
4851: WHERE state_abbrev = p_state_abbrev;
4852:
4853: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4854: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code

Line 4886: pay_us_states c

4882: INTO l_geocode
4883: FROM pay_us_zip_codes z,
4884: pay_us_city_names a,
4885: pay_us_counties b,
4886: pay_us_states c
4887: WHERE c.state_code = a.state_code AND
4888: c.state_abbrev = UPPER(p_state_abbrev)
4889: AND
4890: UPPER(b.county_name) = UPPER(p_county_name)AND --Bug3783309-Changed Initcap to Upper.