APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_LOBS

Line 2823: From fnd_lobs

2819: /* Bug 9719231 */
2820: IF last_day(to_date('01-' || p_effective_month || '-' || p_effective_year,'DD-MM-YYYY')) between last_day(to_date('01-01-2005','DD-MM-YYYY')) and last_day(to_date('01-07-2010','DD-MM-YYYY')) then
2821: Select file_data
2822: Into p_pdf_blob
2823: From fnd_lobs
2824: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_R166_ar_KW.pdf'
2825: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2826: ELSIF last_day(to_date('01-' || p_effective_month || '-' || p_effective_year,'DD-MM-YYYY')) between last_day(to_date('01-08-2010','DD-MM-YYYY')) and last_day(to_date('01-09-2012','DD-MM-YYYY')) then
2827: -- ELSE

Line 2831: From fnd_lobs

2827: -- ELSE
2828: /* 2012 Oct 166 change Bug 14704605 */
2829: Select file_data
2830: Into p_pdf_blob
2831: From fnd_lobs
2832: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_166_10_ar_KW.pdf'
2833: and effective_start_date between to_date('01-08-2010','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2834:
2835: ELSE

Line 2838: From fnd_lobs

2834:
2835: ELSE
2836: Select file_data
2837: Into p_pdf_blob
2838: From fnd_lobs
2839: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_166_12_ar_KW.pdf'
2840: and effective_start_date between to_date('01-10-2012','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2841:
2842: END IF;

Line 2847: From fnd_lobs

2843: ELSIF (p_report = 'REPORT167') THEN
2844: IF g_report_old = 'Y' THEN
2845: Select file_data
2846: Into p_pdf_blob
2847: From fnd_lobs
2848: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAYR167_ar_KW.rtf'
2849: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2850: ELSE
2851: Select file_data

Line 2853: From fnd_lobs

2849: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2850: ELSE
2851: Select file_data
2852: Into p_pdf_blob
2853: From fnd_lobs
2854: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_167_06_ar_KW.rtf'
2855: and effective_start_date between to_date('01-01-2006','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2856: END IF;
2857:

Line 2862: From fnd_lobs

2858: ELSIF (p_report ='REPORT168') THEN
2859: IF last_day(to_date('01-' || p_effective_month || '-' || p_effective_year,'DD-MM-YYYY')) <= last_day(to_date('01-09-2012','DD-MM-YYYY')) then
2860: Select file_data
2861: Into p_pdf_blob
2862: From fnd_lobs
2863: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_R168_ar_KW.pdf'
2864: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2865: ELSE
2866: Select file_data

Line 2868: From fnd_lobs

2864: and effective_start_date between to_date('01-01-2005','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2865: ELSE
2866: Select file_data
2867: Into p_pdf_blob
2868: From fnd_lobs
2869: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_168_12_ar_KW.pdf'
2870: and effective_start_date between to_date('01-10-2012','DD-MM-YYYY') and to_date('31-12-4712','DD-MM-YYYY') );
2871:
2872: END IF;