DBA Data[Home] [Help]

APPS.PER_KW_XDO_REPORT dependencies on FND_LOBS

Line 1071: FROM fnd_lobs

1067: BEGIN
1068: IF (p_report='Disability') THEN
1069: SELECT file_data
1070: INTO p_pdf_blob
1071: FROM fnd_lobs
1072: WHERE file_id = (SELECT MAX(file_id)
1073: FROM fnd_lobs
1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE

Line 1073: FROM fnd_lobs

1069: SELECT file_data
1070: INTO p_pdf_blob
1071: FROM fnd_lobs
1072: WHERE file_id = (SELECT MAX(file_id)
1073: FROM fnd_lobs
1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE
1076: SELECT file_data
1077: INTO p_pdf_blob

Line 1078: FROM fnd_lobs

1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE
1076: SELECT file_data
1077: INTO p_pdf_blob
1078: FROM fnd_lobs
1079: WHERE file_id = (SELECT MAX(file_id)
1080: FROM fnd_lobs
1081: WHERE file_name like '%PER_CTR_ar_KW.pdf');
1082: END IF;

Line 1080: FROM fnd_lobs

1076: SELECT file_data
1077: INTO p_pdf_blob
1078: FROM fnd_lobs
1079: WHERE file_id = (SELECT MAX(file_id)
1080: FROM fnd_lobs
1081: WHERE file_name like '%PER_CTR_ar_KW.pdf');
1082: END IF;
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN