To get organization employee details

/*Employee details*/
select employee_number,
       full_name,
       sex,
       papf.date_of_birth,
       papf.marital_status,
       h.name,
       pa.address_line1,
       pa.address_line2,
       pa.address_line3,
       ADD_INFORMATION13,
       ADD_INFORMATION14,
       ADD_INFORMATION15 ,
       papf.party_id ,
       pp.PHONE_NUMBER
from
per_all_people_f papf,
per_all_assignments_f paaf,
per_grades_tl pgt,
apps.hr_all_organization_units h,
per_addresses_v pa,
PER_PHONES pp
where 1=1
and papf.party_id = pp.party_id
and papf.person_id = paaf.person_id
and papf.effective_end_date = paaf.effective_end_date
and pgt.grade_id = paaf.grade_id
and papf.sex = ''
and papf.marital_status  in ''
and paaf.organization_id = h.organization_id
and h.name not like ''
and pa.person_id = papf.person_id
and papf.CURRENT_EMPLOYEE_FLAG = 'Y'
and papf.full_name like ''
and papf.DATE_OF_BIRTH > ''
and pgt.name like ''