2103: IS
2104: BEGIN
2105: If p_report = 'MAIN' then
2106: /*Changing thequery for performance issue for bug 7597523 */
2107: /* trying to use FND_LOBS_N1 index */
2108: /*SELECT file_data
2109: INTO p_pdf_blob
2110: FROM fnd_lobs
2111: WHERE file_id = (SELECT MAX(file_id)
2106: /*Changing thequery for performance issue for bug 7597523 */
2107: /* trying to use FND_LOBS_N1 index */
2108: /*SELECT file_data
2109: INTO p_pdf_blob
2110: FROM fnd_lobs
2111: WHERE file_id = (SELECT MAX(file_id)
2112: FROM fnd_lobs
2113: WHERE file_name like '%PAY_PRG_ar_AE.pdf'); */
2114: SELECT file_data
2108: /*SELECT file_data
2109: INTO p_pdf_blob
2110: FROM fnd_lobs
2111: WHERE file_id = (SELECT MAX(file_id)
2112: FROM fnd_lobs
2113: WHERE file_name like '%PAY_PRG_ar_AE.pdf'); */
2114: SELECT file_data
2115: INTO p_pdf_blob
2116: FROM fnd_lobs
2112: FROM fnd_lobs
2113: WHERE file_name like '%PAY_PRG_ar_AE.pdf'); */
2114: SELECT file_data
2115: INTO p_pdf_blob
2116: FROM fnd_lobs
2117: WHERE file_id =
2118: ( SELECT MAX(file_id)
2119: from FND_LOBS
2120: WHERE PROGRAM_NAME = 'PAY_PRG_ar_AE.pdf'
2115: INTO p_pdf_blob
2116: FROM fnd_lobs
2117: WHERE file_id =
2118: ( SELECT MAX(file_id)
2119: from FND_LOBS
2120: WHERE PROGRAM_NAME = 'PAY_PRG_ar_AE.pdf'
2121: and program_tag= 'TMP:XDO:XDOTMPLATE1:SEED'
2122: and nvl(EXPIRATION_DATE ,trunc(sysdate)) = trunc(sysdate)
2123: );