APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_GB_XDO_TEMPLATES

Line 971: WHERE file_id = (SELECT MAX(file_id) FROM per_gb_xdo_templates

967: BEGIN
968:
969: SELECT file_data INTO p_pdf_blob
970: FROM fnd_lobs
971: WHERE file_id = (SELECT MAX(file_id) FROM per_gb_xdo_templates
972: WHERE file_name like '%ES_company_cert.pdf%');
973: EXCEPTION
974: WHEN no_data_found THEN
975: NULL;