IN below query working in production but not in testing

Hi Team,

when i do query in testing suite national id number is coming with data but in testing suite having data and coming production working find could please assist on where my condition wrong.

 ppnf.Full_Name,

  pni.NATIONAL_IDENTIFIER_NUMBER,

  Pn.PASSPORT_NUMBER,

  pp.attribute3 as "Business Card Title",

  to_char(ppos.ORIGINAL_DATE_OF_HIRE, 'DD-MM-YYYY') Hire_Date,

  to_char(CURRENT_DATE,'DD-MM-YYYY')

from

  --PER_PERSON_SECURED_LIST_V papf,

  per_all_people_f papf,

   PER_PERSON_NAMES_F ppnf,

 --PER_ASSIGNMENT_SECURED_LIST_V paaf,

 per_all_assignments_f paaf,

 PER_PERSONS pp,

 PER_NATIONAL_IDENTIFIERS pni,