APPS.PER_AE_XDO_REPORT dependencies on FND_LOBS

Line 1280: FROM fnd_lobs

1276: BEGIN
1277: IF (p_report='Visa') THEN
1278: SELECT file_data
1279: INTO p_pdf_blob
1280: FROM fnd_lobs
1281: WHERE file_id = (SELECT MAX(file_id)
1282: FROM fnd_lobs
1283: WHERE file_name like '%PER_VIS_ar_AE.pdf');
1284: ELSIF (p_report='Passport') THEN

Line 1282: FROM fnd_lobs

1278: SELECT file_data
1279: INTO p_pdf_blob
1280: FROM fnd_lobs
1281: WHERE file_id = (SELECT MAX(file_id)
1282: FROM fnd_lobs
1283: WHERE file_name like '%PER_VIS_ar_AE.pdf');
1284: ELSIF (p_report='Passport') THEN
1285: SELECT file_data
1286: INTO p_pdf_blob

Line 1287: FROM fnd_lobs

1283: WHERE file_name like '%PER_VIS_ar_AE.pdf');
1284: ELSIF (p_report='Passport') THEN
1285: SELECT file_data
1286: INTO p_pdf_blob
1287: FROM fnd_lobs
1288: WHERE file_id = (SELECT MAX(file_id)
1289: FROM fnd_lobs
1290: WHERE file_name like '%PER_PASS_ar_AE.pdf');
1291: ELSE

Line 1289: FROM fnd_lobs

1285: SELECT file_data
1286: INTO p_pdf_blob
1287: FROM fnd_lobs
1288: WHERE file_id = (SELECT MAX(file_id)
1289: FROM fnd_lobs
1290: WHERE file_name like '%PER_PASS_ar_AE.pdf');
1291: ELSE
1292: SELECT file_data
1293: INTO p_pdf_blob

Line 1294: FROM fnd_lobs

1290: WHERE file_name like '%PER_PASS_ar_AE.pdf');
1291: ELSE
1292: SELECT file_data
1293: INTO p_pdf_blob
1294: FROM fnd_lobs
1295: WHERE file_id = (SELECT MAX(file_id)
1296: FROM fnd_lobs
1297: WHERE file_name like '%PER_CTR_ar_AE.rtf');
1298: END IF;

Line 1296: FROM fnd_lobs

1292: SELECT file_data
1293: INTO p_pdf_blob
1294: FROM fnd_lobs
1295: WHERE file_id = (SELECT MAX(file_id)
1296: FROM fnd_lobs
1297: WHERE file_name like '%PER_CTR_ar_AE.rtf');
1298: END IF;
1299: EXCEPTION
1300: WHEN NO_DATA_FOUND THEN