Expenditure Items Not Cost Distributed For An Employee

     SELECT PAPF.PERSON_ID,HOU.NAME INCURRED_ORG,
       PE.INCURRED_BY_ORGANIZATION_ID,
       PEI.CC_PRVDR_ORGANIZATION_ID ,
       NVL(CDL.TRANSFER_STATUS_CODE,' ') TRANSFER_STATUS_CODE ,
       PE.EXPENDITURE_ID,
       PE.EXPENDITURE_STATUS_CODE,
       PE.EXPENDITURE_CLASS_CODE,
       PE.EXPENDITURE_GROUP,
       PE.INCURRED_BY_PERSON_ID,
       PAPF.FULL_NAME,
       PEI.EXPENDITURE_ITEM_ID,
       PEI.EXPENDITURE_TYPE,
       PEI.EXPENDITURE_ITEM_DATE,
       PEI.COST_DISTRIBUTED_FLAG,
       NVL(CDL.TRANSFER_REJECTION_REASON,' ') TRANSFER_REJECTION_REASON,
       PEI.JOB_ID,
       PEI.SYSTEM_LINKAGE_FUNCTION,
       PEI.ORIG_TRANSACTION_REFERENCE,
       PEI.TRANSACTION_SOURCE,
       PEI.ORG_ID,
       CDL.LINE_NUM,
       CDL.LINE_TYPE
FROM   PA_COST_DISTRIBUTION_LINES_ALL CDL,
       PA_EXPENDITURES_ALL PE,
       PER_ALL_PEOPLE_F PAPF,
       PA_EXPENDITURE_ITEMS_ALL PEI,
       HR_ALL_ORGANIZATION_UNITS HOU
WHERE  1 = 1
AND    PE.INCURRED_BY_PERSON_ID = PAPF.PERSON_ID
AND    PE.EXPENDITURE_ID = PEI.EXPENDITURE_ID
AND    CDL.EXPENDITURE_ITEM_ID(+) = PEI.EXPENDITURE_ITEM_ID
AND    PEI.ORG_ID = PE.ORG_ID
AND    PEI.ORG_ID = :p_org_id
AND    PAPF.FULL_NAME = :p_employee_name
AND    HOU.ORGANIZATION_ID = PE.INCURRED_BY_ORGANIZATION_ID
and    pei.COST_DISTRIBUTED_FLAG <> 'Y';