Query to fetch employee address details

select papf.person_number,
       papf.person_id,
       papf.start_date,
       ppnf.full_name employee_full_name,
       paf.address_line1,
       paf.address_line2,
       paf.address_line3,
       paf.town_or_city,
       paf.region_1,
       paf.region_2,
       paf.region_3
from   per_all_people_f papf,
       per_addresses paf,
       per_person_names_f ppnf
where  1 = 1
       and trunc(sysdate) between papf.effective_start_date and
                                  papf.effective_end_date
       and papf.person_id = ppnf.person_id
       and trunc(sysdate) between ppnf.effective_start_date and
                                  ppnf.effective_end_date
       and ppnf.name_type = 'GLOBAL'
       and papf.person_id = paf.person_id
       and trunc(sysdate) between paf.date_from and nvl(paf.date_to, sysdate)
--and papf.person_number = :p_person_number -- parameter

------------------------------------------------------------------------------------

SELECT papf.person_number,
       papf.person_id,
       papf.start_date,
       ppnf.full_name
       employee_full_name,
       paf.address_line_1,
       paf.address_line_2,
       paf.address_line_3,
       paf.town_or_city,
       paf.region_1,
       paf.region_2,
       paf.region_3,
       per_address_format.FORMAT_ADDRESS(p_address_line_1 => paf.address_line_1,
       p_address_line_2 => paf.address_line_2,
       p_address_line_3 => paf.address_line_3,
       p_address_line_4 => paf.address_line_4, p_city => paf.town_or_city,
       p_postal_code => paf.postal_code,
       p_long_postal_code => paf.long_postal_code,
       p_state => paf.region_2, p_province => paf.region_3,
       p_county => paf.region_1,
       p_floor_number => paf.floor_number, p_building => paf.building,
       p_country => paf.country, p_addl_address_attribute1 =>
                                 paf.addr_attribute1,
       p_addl_address_attribute2 => paf.addr_attribute2,
       p_addl_address_attribute3 => paf.addr_attribute3,
       p_addl_address_attribute4 => paf.addr_attribute4,
       p_addl_address_attribute5 => paf.addr_attribute5, p_line_break => CHR(10)
       ,
       p_hcm_style_code => 'SUPP_TAX_AND_RPTNG_ADDR', p_address_quality => 3) AS
       Home_Address
FROM   per_all_people_f papf,
       per_addresses_f paf,
       per_person_names_f ppnf
WHERE  1 = 1
       AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND
                                  papf.effective_end_date
       AND papf.person_id = ppnf.person_id
       AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND
                                  ppnf.effective_end_date
       AND ppnf.name_type = 'GLOBAL'
       AND papf.mailing_address_id = paf.address_id
       AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND
                                  paf.effective_end_date