eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_LOBS

Line 2716: From fnd_lobs

2712: /* changed for Oct 2012 Bug 14849011 */
2713: 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
2714: Select file_data
2715: Into p_pdf_blob
2716: From fnd_lobs
2717: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');
2718:
2719: ELSE
2720: Select file_data

Line 2717: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');

2713: 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
2714: Select file_data
2715: Into p_pdf_blob
2716: From fnd_lobs
2717: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');
2718:
2719: ELSE
2720: Select file_data
2721: Into p_pdf_blob

Line 2722: From fnd_lobs

2718:
2719: ELSE
2720: Select file_data
2721: Into p_pdf_blob
2722: From fnd_lobs
2723: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_12_ar_KW.pdf');
2724:
2725: END IF;
2726: ELSIF (p_report='REPORT56') THEN

Line 2723: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_12_ar_KW.pdf');

2719: ELSE
2720: Select file_data
2721: Into p_pdf_blob
2722: From fnd_lobs
2723: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_12_ar_KW.pdf');
2724:
2725: END IF;
2726: ELSIF (p_report='REPORT56') THEN
2727: Select file_data

Line 2729: From fnd_lobs

2725: END IF;
2726: ELSIF (p_report='REPORT56') THEN
2727: Select file_data
2728: Into p_pdf_blob
2729: From fnd_lobs
2730: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');
2731: ELSIF (p_report='REPORT103') THEN
2732: 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
2733: Select file_data

Line 2730: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');

2726: ELSIF (p_report='REPORT56') THEN
2727: Select file_data
2728: Into p_pdf_blob
2729: From fnd_lobs
2730: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');
2731: ELSIF (p_report='REPORT103') THEN
2732: 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
2733: Select file_data
2734: Into p_pdf_blob

Line 2735: From fnd_lobs

2731: ELSIF (p_report='REPORT103') THEN
2732: 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
2733: Select file_data
2734: Into p_pdf_blob
2735: From fnd_lobs
2736: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');
2737: ELSE
2738: Select file_data
2739: Into p_pdf_blob

Line 2736: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');

2732: 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
2733: Select file_data
2734: Into p_pdf_blob
2735: From fnd_lobs
2736: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');
2737: ELSE
2738: Select file_data
2739: Into p_pdf_blob
2740: From fnd_lobs

Line 2740: From fnd_lobs

2736: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');
2737: ELSE
2738: Select file_data
2739: Into p_pdf_blob
2740: From fnd_lobs
2741: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_12_ar_KW.pdf');
2742:
2743: END IF;
2744:

Line 2741: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_12_ar_KW.pdf');

2737: ELSE
2738: Select file_data
2739: Into p_pdf_blob
2740: From fnd_lobs
2741: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_12_ar_KW.pdf');
2742:
2743: END IF;
2744:
2745: END IF;