DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PER_ADDRESSES

Line 875: FROM per_addresses pa

871: pa.address_line1 AL1,
872: pa.address_line2 AL2,
873: pa.address_line3 AL3,
874: pa.postal_code postal_code
875: FROM per_addresses pa
876: WHERE pa.primary_flag = 'Y'
877: AND pa.person_id = p_person_id
878: AND p_effective_date BETWEEN pa.date_from
879: AND NVL(pa.date_to,to_date('31-12-4712','DD-MM-YYYY'));