APPS.EDR_ISIGN_TEMPLATE_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 69: fnd_attached_documents fnddoc,

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)
73: AND fnddoc.document_id = fndt.document_id

Line 77: fnd_attached_documents

73: AND fnddoc.document_id = fndt.document_id
74: AND fndt.media_id = fnl.file_id
75: AND fnddoc.document_id =(select max(document_id)
76: from
77: fnd_attached_documents
78: where pk1_value = to_char(l_file_id_template)
79: and entity_name = 'EDR_XSLFO_TEMPLATE');
80:
81: l_position := instr(p_style_sheet, '.xsl',1);