Query for getting SIT Details for the Employees

SELECT
papf.employee_number,
papf.full_name,
pac.segment1,
pac.segment2,
pac.segment3,
pac.segment4,
pac.segment5
FROM
per_all_people_f papf,
fnd_id_flex_structures_tl fifs,
per_analysis_criteria pac,
per_person_analyses ppa
WHERE
papf.business_group_id                 = P_BUSINESS_GROUP_ID
AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.current_employee_flag         = 'Y'
AND UPPER(fifs.id_flex_structure_name) = UPPER('Passport')
AND fifs.id_flex_num = pac.id_flex_num
AND ppa.id_flex_num = fifs.id_flex_num
AND ppa.analysis_criteria_id = pac.analysis_criteria_id
AND ppa.person_id = papf.person_id;