APPS.POS_HEADER_INFO_S SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT count(po_header_id)
      INTO v_count
      FROM POS_ASN_SHOP_CART_DETAILS
     WHERE session_id = p_sessionID;

Line: 32

      SELECT POH.terms_id
        INTO v_termID
        FROM PO_HEADERS_ALL POH,
             POS_ASN_SHOP_CART_DETAILS POS
       WHERE POH.po_header_id = POS.po_header_id
         AND POS.session_id = p_sessionID;

Line: 44

      SELECT terms_id
        INTO v_termID
        FROM PO_VENDOR_SITES
       WHERE vendor_site_id = p_vendorSiteID;