APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_ADDRESSES

Line 1303: FROM per_addresses pa

1299: pa.address_line1 AL1,
1300: pa.address_line2 AL2,
1301: pa.address_line3 AL3,
1302: pa.postal_code postal_code
1303: FROM per_addresses pa
1304: WHERE pa.primary_flag = 'Y'
1305: AND pa.person_id = p_person_id
1306: AND p_effective_date BETWEEN pa.date_from AND NVL(pa.date_to,to_date('31-12-4712','DD-MM-YYYY'));
1307: