Only issue with one person number of the query

@Mandeep Gupta

Summary:

HI Team,

for below working fine but coming to one person number not getting the data. below error coming

error:Data_das

Could u please assist on this.@Mandeep Gupta

Thanks.

Ajay

Content (required):

select DISTINCT papf.Person_number,

    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'),

(case when pc.LEGISLATION_CODE = 'MY'

 then pni.NATIONAL_IDENTIFIER_NUMBER

else Pn.PASSPORT_NUMBER end) nid 

  from

       PER_PERSON_SECURED_LIST_V papf,

         PER_PERSON_NAMES_F ppnf,