SQL query to get the Employee & Default Expense Account Details

select Distinct papf.person_number, paam.assignment_number,ple.NAME legal_employer_name
,pd.name department_name
,ppnf.DISPLAY_NAME EMP_NAME
,ppnf.first_name
,ppnf.LAst_name
, EX.SEGMENT1  
,EX.SEGMENT2 
,EX.SEGMENT3 
,EX.SEGMENT4
,EX.SEGMENT5
,EX.SEGMENT6
,EX.SEGMENT7
,paam.action_code
,PAAM.assignment_status_type
FROM per_all_people_f papf,
       per_all_assignments_m paam
        ,per_legal_employers ple
        ,GL_CODE_COMBINATIONS EX
        ,per_departments pd
        ,per_person_names_f ppnf
where papf.person_id = paam.person_id
and PAAM.assignment_type IN ('E','C')
AND ple.organization_id = paam.legal_entity_id
and   trunc(sysdate) between paam.effective_start_date and paam.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date
     and TRUNC (paam.effective_start_date) BETWEEN ple.effective_start_date(+) AND ple.effective_end_date(+)
   and EX.code_combination_id(+)=paam.default_Code_comb_id   
   AND pd.organization_id(+) = paam.organization_id
      AND TRUNC (paam.effective_start_date) BETWEEN pd.effective_start_date(+) AND pd.effective_end_date(+)
   AND papf.person_id = ppnf.person_id
   and ppnf.name_type = 'GLOBAL'
      AND TRUNC (SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date