616: BEGIN
617: IF (p_report='CHQR') THEN
618: Select file_data
619: Into p_pdf_blob
620: From fnd_lobs
621: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_AE.rtf');
622: END IF;
623:
624: EXCEPTION
617: IF (p_report='CHQR') THEN
618: Select file_data
619: Into p_pdf_blob
620: From fnd_lobs
621: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_AE.rtf');
622: END IF;
623:
624: EXCEPTION
625: when no_data_found then