APPS.HR_US_PYZIPCHK dependencies on PER_US_INVAL_ADDRESSES

Line 75: insert into per_us_inval_addresses (address_id)

71: ,p_city_name
72: ,p_zip_code
73: ,'Y');
74: if (l_per_addr = '00-000-0000') then
75: insert into per_us_inval_addresses (address_id)
76: values (p_address_id);
77: commit;
78: end if;
79: ELSIF length(p_zip_code) = 7 THEN -- Canadian addresses

Line 86: insert into per_us_inval_addresses (address_id)

82: p_zip_code = Postal Code */
83: OPEN ca_address(p_city_name, p_county_name, p_zip_code);
84: FETCH ca_address INTO l_add_valid;
85: IF l_add_valid = 0 THEN
86: insert into per_us_inval_addresses (address_id)
87: values (p_address_id);
88: commit;
89: END IF;
90: CLOSE ca_address;