396: (SELECT CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, 'N' ismod,CLM_EFFECTIVE_DATE effdate,APPROVED_DATE APPROVED_DATE,CLM_EDAGEN_DATE
397: FROM po_headers_all
398: WHERE uda_template_id IS NOT NULL
399: UNION
400: SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where
401: po_header_id = a.DOCUMENT_ID and draft_id = a.DRAFT_ID) APPROVED_DATE,CLM_EDAGEN_DATE
402: FROM po_drafts a)
403: WHERE (decode(P_IS_MOD,'Base Documents','N','Modifications','Y') = ismod or P_IS_MOD = 'Both')
404: AND