Query for getting Address Details for the Employees.

SELECT
papf.employee_number,
pa.style,
pa.address_line1,
pa.address_line2,
pa.address_line3,
pa.addresss_type,
pa.country,
pa.postal_code,
pa.telephone_number_1,
pa.town_or_city
FROM
per_all_people_f papf,
per_addresses pa
WHERE
papf.business_group_id = P_BUSINESS_GROUP_ID
AND papf.current_employee_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.person_id = pa.person_id;