246: l_award_qty_obj.quantity,
247: l_award_qty_obj.amount
248: FROM gms_distribution_details awdd,
249: gms_distributions awd,
250: gms_awards_all a
251: WHERE awd.document_distribution_id = awdd.document_distribution_id
252: AND awd.document_header_id = awdd.document_header_id
253: AND awd.document_distribution_id = l_distribution_id
254: AND awd.document_header_id = l_doc_header_id