Query for getting Phone Details for the Employees.

SELECT
papf.employee_number,
pp.phone_type,
pp.phone_number
FROM
per_all_people_f papf,
per_phones pp
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 = pp.parent_id;