Benefits Certification Validation Report

Summary

Getting duplicate value. Not able to figure which join is missing

Content

Below is my query. I am getting duplicates. Not able to figure missing join:

SELECT PAPF.PERSON_NUMBER

  ,PPN.LAST_NAME

  ,PPN.FIRST_NAME

  ,PAAM.ASSIGNMENT_NUMBER

  ,(SELECT NVL(MEANING,'') 

       FROM  FND_LOOKUP_VALUES_VL

       WHERE LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'

       AND   ENABLED_FLAG = 'Y'

       AND   LOOKUP_CODE = PAAM.BARGAINING_UNIT_CODE) BARGAINING_UNIT

  ,HOTL.NAME DEPARTMENT_NAME

  ,PCR.CONTACT_TYPE

  ,DPNT.PERSON_NUMBER DPNT_NUM 

  ,SUBSTR(DPNT_NID.national_identifier_number,8) SSN

  ,bec.ELIG_CVRD_DPNT_ID,BEC.PRTT_ENRT_RSLT_ID,bec.ORGNL_OIPL_CVG_STRT_DT,bec.ORGNL_PLAN_CVG_STRT_DT