APPS.HR_CA_FF_UDFS dependencies on PAY_US_STATES

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

2621: IF substr(p_jurisdiction_code, 8,4) = '0000' THEN
2622:
2623: IF substr(p_jurisdiction_code, 4,3) = '000' THEN
2624:
2625: -- Only entered a state geo, check against PAY_US_STATES.
2626:
2627: SELECT 'S'
2628: INTO v_valid_jurisdiction
2629: FROM PAY_US_STATES

Line 2629: FROM PAY_US_STATES

2625: -- Only entered a state geo, check against PAY_US_STATES.
2626:
2627: SELECT 'S'
2628: INTO v_valid_jurisdiction
2629: FROM PAY_US_STATES
2630: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2);
2631:
2632: ELSE
2633:

Line 4237: FROM pay_us_states

4233: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo
4234: -- same county name can exists in many states
4235: SELECT state_code
4236: INTO l_state_code
4237: FROM pay_us_states
4238: WHERE state_abbrev = p_state_abbrev;
4239:
4240: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4241: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code

Line 4273: pay_us_states c

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
4277: b.county_name = INITCAP(p_county_name)AND