APPS.PAY_FI_ARCHIVE_PYSA dependencies on PER_ADDRESSES
Line 710: FROM per_addresses pa
706: pa.address_line1 AL1,
707: pa.address_line2 AL2,
708: pa.address_line3 AL3,
709: pa.postal_code postal_code 710: FROM per_addresses pa 711: WHERE pa.primary_flag = 'Y'
712: AND pa.person_id = p_person_id
713: AND p_effective_date BETWEEN pa.date_from
714: AND NVL(pa.date_to,to_date('31-12-4712','DD-MM-YYYY'));