APPS.PAY_SA_GOSI_REPORTS dependencies on FND_LOBS

Line 3905: From fnd_lobs

3901: BEGIN
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

Line 3910: 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
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

Line 3915: 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
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