APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_LOBS

Line 2321: From fnd_lobs

2317: BEGIN
2318: IF (p_report='REPORT166') THEN
2319: Select file_data
2320: Into p_pdf_blob
2321: From fnd_lobs
2322: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_R166_ar_KW.pdf'
2323: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2324: ELSIF (p_report = 'REPORT167') THEN
2325: IF g_report_old = 'Y' THEN

Line 2328: From fnd_lobs

2324: ELSIF (p_report = 'REPORT167') THEN
2325: IF g_report_old = 'Y' THEN
2326: Select file_data
2327: Into p_pdf_blob
2328: From fnd_lobs
2329: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAYR167_ar_KW.rtf'
2330: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2331: ELSE
2332: Select file_data

Line 2334: From fnd_lobs

2330: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2331: ELSE
2332: Select file_data
2333: Into p_pdf_blob
2334: From fnd_lobs
2335: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_167_06_ar_KW.rtf'
2336: and effective_start_date between to_date('01-01-2006','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2337: END IF;
2338:

Line 2342: From fnd_lobs

2338:
2339: ELSIF (p_report ='REPORT168') THEN
2340: Select file_data
2341: Into p_pdf_blob
2342: From fnd_lobs
2343: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_R168_ar_KW.pdf'
2344: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2345: END IF;
2346: EXCEPTION