27: IF v_count = 1 THEN
28:
29: -- all shipments in the shopping cart for this particular session ID
30: -- belong to the same PO, so we grab the term from the terms_id from
31: -- po_headers_all.
32: SELECT POH.terms_id
33: INTO v_termID
34: FROM PO_HEADERS_ALL POH,
35: POS_ASN_SHOP_CART_DETAILS POS
30: -- belong to the same PO, so we grab the term from the terms_id from
31: -- po_headers_all.
32: SELECT POH.terms_id
33: INTO v_termID
34: FROM PO_HEADERS_ALL POH,
35: POS_ASN_SHOP_CART_DETAILS POS
36: WHERE POH.po_header_id = POS.po_header_id
37: AND POS.session_id = p_sessionID;
38: