APPS.HR_US_PYZIPCHK dependencies on PER_US_INVAL_LOCATIONS

Line 156: insert into per_us_inval_locations (location_id)

152: ,p_zip_code
153: ,'Y');
154: if (l_hr_addr = '00-000-0000') then
155: --
156: insert into per_us_inval_locations (location_id)
157: values (p_location_id);
158: commit;
159: end if;
160: ELSIF length(p_zip_code) = 7 THEN

Line 167: insert into per_us_inval_locations (location_id)

163: p_zip_code = Postal Code */
164: OPEN ca_locations(p_city_name, p_county_name, p_zip_code);
165: FETCH ca_locations INTO l_loc_valid;
166: IF l_loc_valid = 0 THEN
167: insert into per_us_inval_locations (location_id)
168: values (p_location_id);
169: commit;
170: END IF;
171: CLOSE ca_locations;