233: draft_id,
234: po_header_id,
235: destination_type_code,
236: destination_organization_id
237: FROM po_distributions_draft_all
238: WHERE po_line_id = L_po_line_id_tbl(i)
239: AND draft_id = p_par_draft_id
240: AND po_header_id = p_po_header_id
241: AND ROWNUM = 1) pldor
333: AND old_amount_ordered IS NULL THEN NULL
334: ELSE Nvl(old_amount_ordered, 0) - Nvl(amount_ordered, 0)
335: END ) AMOUNT_FUNDED,
336: funded_value
337: FROM po_distributions_draft_all PDD
338: WHERE PDD.po_header_id = p_po_header_id
339: AND change_status = 'NEW'
340: AND PDD.draft_id = p_par_draft_id
341: AND PDD.po_line_id = L_po_line_id_tbl(i);