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 2557: From fnd_lobs

2553: BEGIN
2554: IF (p_report='REPORT55') THEN
2555: Select file_data
2556: Into p_pdf_blob
2557: From fnd_lobs
2558: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');
2559: ELSIF (p_report='REPORT56') THEN
2560: Select file_data
2561: Into p_pdf_blob

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

2554: IF (p_report='REPORT55') THEN
2555: Select file_data
2556: Into p_pdf_blob
2557: From fnd_lobs
2558: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');
2559: ELSIF (p_report='REPORT56') THEN
2560: Select file_data
2561: Into p_pdf_blob
2562: From fnd_lobs

Line 2562: From fnd_lobs

2558: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R55_ar_KW.pdf');
2559: ELSIF (p_report='REPORT56') THEN
2560: Select file_data
2561: Into p_pdf_blob
2562: From fnd_lobs
2563: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');
2564: ELSIF (p_report='REPORT103') THEN
2565: Select file_data
2566: Into p_pdf_blob

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

2559: ELSIF (p_report='REPORT56') THEN
2560: Select file_data
2561: Into p_pdf_blob
2562: From fnd_lobs
2563: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');
2564: ELSIF (p_report='REPORT103') THEN
2565: Select file_data
2566: Into p_pdf_blob
2567: From fnd_lobs

Line 2567: From fnd_lobs

2563: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R56_ar_KW.pdf');
2564: ELSIF (p_report='REPORT103') THEN
2565: Select file_data
2566: Into p_pdf_blob
2567: From fnd_lobs
2568: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');
2569: END IF;
2570: EXCEPTION
2571: when no_data_found then

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

2564: ELSIF (p_report='REPORT103') THEN
2565: Select file_data
2566: Into p_pdf_blob
2567: From fnd_lobs
2568: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_R103_ar_KW.pdf');
2569: END IF;
2570: EXCEPTION
2571: when no_data_found then
2572: null;