APPS.HR_US_FF_UDFS dependencies on PAY_US_STATES

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

3032: IF substr(p_jurisdiction_code, 8,4) = '0000' THEN
3033:
3034: IF substr(p_jurisdiction_code, 4,3) = '000' THEN
3035:
3036: -- Only entered a state geo, check against PAY_US_STATES.
3037:
3038: SELECT 'S'
3039: INTO v_valid_jurisdiction
3040: FROM PAY_US_STATES

Line 3040: FROM PAY_US_STATES

3036: -- Only entered a state geo, check against PAY_US_STATES.
3037:
3038: SELECT 'S'
3039: INTO v_valid_jurisdiction
3040: FROM PAY_US_STATES
3041: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2);
3042:
3043: ELSE
3044:

Line 4785: FROM pay_us_states

4781: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo
4782: -- same county name can exists in many states
4783: SELECT state_code
4784: INTO l_state_code
4785: FROM pay_us_states
4786: WHERE state_abbrev = p_state_abbrev;
4787:
4788: hr_utility.set_location('hr_us_ff_udfs.addr_val', 5);
4789: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code

Line 4821: pay_us_states c

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
4825: UPPER(b.county_name) = UPPER(p_county_name)AND --Bug3783309-Changed Initcap to Upper.