[Home] [Help]
634: BEGIN
635: IF (p_report='CHQR') THEN
636: Select file_data
637: Into p_pdf_blob
638: From fnd_lobs
639: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_AE.rtf');
640: END IF;
641:
642: EXCEPTION
635: IF (p_report='CHQR') THEN
636: Select file_data
637: Into p_pdf_blob
638: From fnd_lobs
639: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_AE.rtf');
640: END IF;
641:
642: EXCEPTION
643: when no_data_found then