457: THEN
458:
459: SELECT 'Y'
460: INTO lv_rcpt_tax_exists
461: FROM DUAL
462: WHERE EXISTS (SELECT '1'
463: FROM JAI_RCV_LINE_TAXES
464: WHERE shipment_line_id IN (SELECT shipment_line_id
465: FROM RCV_TRANSACTIONS
472: THEN
473:
474: SELECT 'Y'
475: INTO lv_po_tax_exists
476: FROM DUAL
477: WHERE EXISTS (SELECT '1'
478: FROM JAI_PO_TAXES
479: WHERE po_header_id = pr_new.po_header_id
480: AND po_line_id = pr_new.po_line_id);