DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_DOCUMENTS

Line 1155: fnd_documents doc

1151: -- Does this requisition line have any attachments?
1152: SELECT COUNT(*)
1153: INTO v_header_attach_count
1154: FROM fnd_attached_documents ad,
1155: fnd_documents doc
1156: WHERE ad.entity_name = 'REQ_HEADERS'
1157: AND ad.pk1_value = TO_CHAR(p_requisition_header_id)
1158: AND ad.document_id = doc.document_id
1159: AND doc.category_id = v_att_category_id;

Line 1163: fnd_documents doc

1159: AND doc.category_id = v_att_category_id;
1160: SELECT COUNT(*)
1161: INTO v_item_attach_count
1162: FROM fnd_attached_documents ad,
1163: fnd_documents doc
1164: WHERE ad.entity_name = 'REQ_LINES'
1165: AND ad.pk1_value = TO_CHAR(p_requisition_line_id)
1166: AND ad.document_id = doc.document_id
1167: AND doc.category_id = v_att_category_id;