84: when no_data_found then po_hold_exists := 'N';
85: end;
86:
87:
88: elsif p_potableused = 'po_requisition_lines' then
89: begin
90: select sum(nvl(prl.quantity,0) - nvl(prl.quantity_cancelled,0)
91: - nvl(prl.quantity_delivered,0))
92: into
90: select sum(nvl(prl.quantity,0) - nvl(prl.quantity_cancelled,0)
91: - nvl(prl.quantity_delivered,0))
92: into
93: poqty
94: from po_requisition_lines prl,
95: so_drop_ship_sources sodss
96: where sodss.line_id = p_lineid
97: and prl.requisition_line_id = sodss.requisition_line_id
98: and sodss.header_id = p_headerid