APPS.EDR_ISIGN_TEMPLATE_PKG dependencies on FND_LOBS

Line 68: fnd_lobs fnl,

64:
65:
66: SELECT fnl.FILE_DATA into x_ss_blob
67: FROM
68: fnd_lobs fnl,
69: fnd_attached_documents fnddoc,
70: fnd_documents_vl fndt
71: WHERE fnddoc.ENTITY_NAME = 'EDR_XSLFO_TEMPLATE'
72: AND fnddoc.pk1_value = to_Char(l_file_id_template)

Line 120: fnd_lobs fl, fnd_documents_vl fdt, edr_files_b isign_files

116: --Bug : 3499311 : Start - Specified number format in call TO_NUMBER
117: select fl.file_data, isign_files.ORIGINAL_FILE_NAME, isign_files.FILE_NAME
118: into l_file_data, l_file_name, l_display_name
119: from
120: fnd_lobs fl, fnd_documents_vl fdt, edr_files_b isign_files
121: where
122: isign_files.file_id = to_number(p_event_key,'999999999999.999999')
123: and fdt.document_id = isign_files.fnd_document_id
124: and fl.file_id = fdt.media_id;