Oracle Fusion - Oracle Project Resource Allocation

 SELECT PA.project_id

       ,ppa.segment1 project_code

       ,ppnf.person_id

       ,START_DATE_ACTIVE

       ,END_DATE_ACTIVE 

       ,(ppnf.first_name||' '||ppnf.last_name) EMP_Name
  FROM PJF_PROJECT_PARTIES  PA, per_person_names_f ppnf
     , PJF_PROJECTS_ALL_VL PPA
 WHERE pa.project_id = ppa.project_id
   AND ppa.segment1 = 'PROJECT_CODE'
   AND ppnf.person_id = pa.RESOURCE_SOURCE_ID
   AND ppnf.name_type = 'GLOBAL'
   AND SYSDATE BETWEEN TRUNC(ppnf.effective_start_date) 

                   AND TRUNC(ppnf.effective_end_date)