DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_DOCUMENTS

Line 664: FROM fnd_attached_documents ad, fnd_documents doc

660:
661: -- Does this requisition line have any attachments?
662: SELECT count(*)
663: INTO v_header_attach_count
664: FROM fnd_attached_documents ad, fnd_documents doc
665: WHERE ad.entity_name = 'REQ_HEADERS'
666: AND ad.pk1_value = to_char(p_requisition_header_id)
667: AND ad.document_id = doc.document_id
668: AND doc.category_id = v_att_category_id;

Line 672: FROM fnd_attached_documents ad, fnd_documents doc

668: AND doc.category_id = v_att_category_id;
669:
670: SELECT count(*)
671: INTO v_item_attach_count
672: FROM fnd_attached_documents ad, fnd_documents doc
673: WHERE ad.entity_name = 'REQ_LINES'
674: AND ad.pk1_value = to_char(p_requisition_line_id)
675: AND ad.document_id = doc.document_id
676: AND doc.category_id = v_att_category_id;