APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PER_ADDRESSES

Line 291: FROM per_addresses addr

287: ,addr.add_information14 building
288: ,addr.add_information15 stairway
289: ,addr.add_information16 floor
290: ,addr.add_information17 door
291: FROM per_addresses addr
292: WHERE addr.person_id = p_person_id
293: AND addr.primary_flag = 'Y'
294: AND p_termination_date between addr.date_from and
295: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));