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_SA_GOSI_REPORTS dependencies on PER_GB_XDO_TEMPLATES

Line 3906: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G32003_ar_SA.pdf');

3902: IF (p_report='Form 3') THEN
3903: Select file_data
3904: Into p_pdf_blob
3905: From fnd_lobs
3906: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G32003_ar_SA.pdf');
3907: ELSIF (p_report = 'Form 4') THEN
3908: Select file_data
3909: Into p_pdf_blob
3910: From fnd_lobs

Line 3911: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G42003_ar_SA.pdf');

3907: ELSIF (p_report = 'Form 4') THEN
3908: Select file_data
3909: Into p_pdf_blob
3910: From fnd_lobs
3911: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G42003_ar_SA.pdf');
3912: ELSIF (p_report ='Form 5') THEN
3913: Select file_data
3914: Into p_pdf_blob
3915: From fnd_lobs

Line 3916: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G52003_ar_SA.pdf');

3912: ELSIF (p_report ='Form 5') THEN
3913: Select file_data
3914: Into p_pdf_blob
3915: From fnd_lobs
3916: Where file_id = (select max(file_id) from per_gb_xdo_templates where file_name like '%PAY_G52003_ar_SA.pdf');
3917: END IF;
3918: EXCEPTION
3919: when no_data_found then
3920: null;