IF ( pProductCode <> vEmpty || pProductName <> vEmpty ) THEN
        WITH filtered_product AS (
            SELECT F.product_id, F.product_code, F.product_name
            FROM m_product F
            WHERE tenant_id = pTenantId
            AND F.product_code= pProductCode
            AND F.product_name= pProductName
        );
    ELSE
        WITH filtered_product AS (
            SELECT F.product_id, F.product_code, F.product_name
            FROM m_product F
        );
    END IF;