Get SIT Details in Oracle EBS - Special Information Types

select ppa.date_from,ppa.date_to,pac.*
  from per_all_people_f papf, per_all_assignments_f paaf,per_person_analyses PPA,per_analysis_criteria pac,fnd_id_flex_structures fifs
 where papf.employee_number = 'XXXX'
   AND SYSDATE BETWEEN papf.effective_start_date AND
       papf.effective_end_date
   and papf.current_employee_flag = 'Y'
   and paaf.person_id = papf.person_id
   and paaf.assignment_type = 'E'
   AND SYSDATE BETWEEN paaf.effective_start_date AND
       paaf.effective_end_date
   and ppa.person_id = papf.person_id
   and pac.id_flex_num = ppa.id_flex_num
   and pac.analysis_criteria_id = ppa.analysis_criteria_id
   and fifs.id_flex_num = ppa.id_flex_num
   and fifs.id_flex_structure_code = 'XXXX'--This is SIT code