APPS.HR_CA_FF_UDFS dependencies on PAY_US_STATES

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

2658: IF substr(p_jurisdiction_code, 8,4) = '0000' THEN
2659:
2660: IF substr(p_jurisdiction_code, 4,3) = '000' THEN
2661:
2662: -- Only entered a state geo, check against PAY_US_STATES.
2663:
2664: SELECT 'S'
2665: INTO v_valid_jurisdiction
2666: FROM PAY_US_STATES

Line 2666: FROM PAY_US_STATES

2662: -- Only entered a state geo, check against PAY_US_STATES.
2663:
2664: SELECT 'S'
2665: INTO v_valid_jurisdiction
2666: FROM PAY_US_STATES
2667: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2);
2668:
2669: ELSE
2670:

Line 4274: FROM pay_us_states

4270: WHEN TOO_MANY_ROWS THEN -- city/zip does not uniquely defn geo
4271: -- same county name can exists in many states
4272: SELECT state_code
4273: INTO l_state_code
4274: FROM pay_us_states
4275: WHERE state_abbrev = p_state_abbrev;
4276:
4277: hr_utility.set_location('hr_ca_ff_udfs.addr_val', 5);
4278: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code

Line 4310: pay_us_states c

4306: INTO l_geocode
4307: FROM pay_us_zip_codes z,
4308: pay_us_city_names a,
4309: pay_us_counties b,
4310: pay_us_states c
4311: WHERE c.state_code = a.state_code AND
4312: c.state_abbrev = UPPER(p_state_abbrev)
4313: AND
4314: b.county_name = INITCAP(p_county_name)AND