299:
300: CURSOR C_asn_attach (l_header_intf_id NUMBER) IS
301: select distinct rti.asn_attach_id
302: from rcv_transactions_interface rti,
303: fnd_attached_documents fad
304: where rti.header_interface_id = l_header_intf_id
305: and rti.asn_attach_id is not null
306: and to_char(rti.asn_attach_id) = fad.PK1_value
307: and fad.entity_name = 'ASN_ATTACH';