SQL query for Employee and his HR details

Summary

My sql query is not fetching the updated HR details

Content

Hi Team,

For some departments we changed the HR Approval on April 1^st from on that date our report not fetching new data.

For HR Approval we write below sql query.

(SELECT PPNF4.FULL_NAME       

           FROM PER_PERSON_NAMES_F PPNF4,

                PER_ASG_RESPONSIBILITIES PAR

          WHERE PPNF4.PERSON_ID=PAR.PERSON_ID                           

            AND PAR.RESPONSIBILITY_TYPE(+) = 'HRA_REP'

AND  INSTR (PAAM.LEGAL_ENTITY_ID || PAAM.LOCATION_ID  || PAAM.BUSINESS_UNIT_ID , PAR.LEGAL_ENTITY_ID || PAR.LOCATION_ID || PAR.BUSINESS_UNIT_ID) > 0

AND PPNF4.NAME_TYPE = 'GLOBAL'

AND ROWNUM =1