382: begin
383:
384: select po_line_id, TAXABLE_FLAG, ESTIMATED_TAX_AMOUNT
385: into l_po_line_id, l_isTaxable, x_ESTIMATED_TAX_AMOUNT
386: from po_line_locations_archive_all
387: where line_location_id = p_po_line_loc_id;
388:
389: if (l_isTaxable = 'Y') then
390: select TAX_NAME, TYPE_1099, TAX_CODE_ID
423: begin
424:
425: select TAXABLE_FLAG
426: into X_TAXABLE
427: from po_line_locations_archive_all
428: where line_location_id = p_po_line_loc_id;
429:
430: if (X_TAXABLE = 'Y') then
431: X_TAXABLE := 'Taxable';