APPS.PAY_SA_GOSI_REPORTS dependencies on FND_LOBS

Line 3907: From fnd_lobs

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

Line 3912: From fnd_lobs

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

Line 3917: From fnd_lobs

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